+ Reply to Thread
Results 1 to 2 of 2

Having memory lapse. Syntax for MsgBox to show combobox.Value?

  1. #1
    Registered User
    Join Date
    08-27-2012
    Location
    Santa Ana, CA USA
    MS-Off Ver
    Excel 2010
    Posts
    43

    Having memory lapse. Syntax for MsgBox to show combobox.Value?

    Hello, all. Maybe once or twice a year someone asks me to make a change to a macro'd workbook I made some time ago, and since I am not a programmer by trade, I start to forget the little things like proper syntax.

    As the title suggests I am trying to use a msgbox to show all textbox/combobox values before proceeding. I get a syntax error if I try something like:

    MsgBox "Spring type: " & SpringTypeComboBox.Value

    What would be the proper way to express this?



    Thank you in advance


    *Edit* In case it makes a difference or there's something inherantly wrong with the process, the comboboxes' values have not been dropped in cells yet. There are a short sequence of userforms where people enter 1 item of information at a time and the msgbox is supposed to show them what is about to be written to the sheet.
    Last edited by smaier69; 04-24-2015 at 08:14 PM.

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    22,013

    Re: Having memory lapse. Syntax for MsgBox to show combobox.Value?

    That syntax is correct.
    Everyone who confuses correlation and causation ends up dead.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Syntax error on msgbox
    By Excel_vba in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-14-2014, 05:09 PM
  2. [SOLVED] how to add counter in msgbox to show remain times the message will show vba code
    By sspreyer in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-25-2013, 06:46 AM
  3. msgbox syntax
    By tryer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-04-2008, 12:22 PM
  4. syntax for code in MsgBox()?
    By Ouka in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-20-2005, 04:05 PM
  5. [SOLVED] [SOLVED] MsgBox Syntax
    By scott in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-07-2005, 07:06 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1