Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 2 of 2

Thread: cell value in a msgbox

  1. #1
    Join Date
    16th December 2005
    Posts
    1

    cell value in a msgbox

    Hi everybody,

    I would like to create a msgbox, which shows the value of one selected
    cell.

    for example:

    Msgbox "here is the current count of inventory (cell a1001)"

    In Excel, I am having trouble showing the value of cell "A1001" in the above mentioned msgbox.

    Any assistance will be truly appreciated.

    Sincerely,
    Martin

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    14th July 2004
    Posts
    10,539

    Re: cell value in a msgbox

    Martin

    Try this.
    VB:
    Msgbox "here is the current count of inventory " & Range("A1001") 
    
    
    This will show the value of A1001 in the active sheet, if you need to get it from another sheet you'll need to reference it.
    VB:
    Msgbox "here is the current count of inventory " & Worksheets("Sheet1").Range("A1001") 
    
    

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Show MsgBox If Cell Format Met
    By toecutter in forum EXCEL HELP
    Replies: 3
    Last Post: August 2nd, 2007, 06:34
  2. Cell Change Shows Msgbox
    By abbeville in forum EXCEL HELP
    Replies: 2
    Last Post: March 31st, 2007, 04:52
  3. Vba: Msgbox When Value In Cell Is Value Or N/a
    By tuecker in forum EXCEL HELP
    Replies: 5
    Last Post: March 31st, 2007, 00:30
  4. Macro For Cell Deletion Relative To Msgbox
    By Ben103 in forum EXCEL HELP
    Replies: 2
    Last Post: March 21st, 2007, 05:32
  5. Cell Data in MsgBox
    By dumble in forum EXCEL HELP
    Replies: 9
    Last Post: May 22nd, 2006, 02:14

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno