+ Reply to Thread
Results 1 to 4 of 4

Message box for selection!!

  1. #1
    Registered User
    Join Date
    04-11-2013
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    92

    Message box for selection!!

    Hello everyone,

    This is the problem. I need a macro that will do the following:

    Create a pop - up message box that says:

    " Please specify the deal is:

    1- blablabla
    2-blablabla
    3-blablabla
    4- none of these "

    The user should then input either 1,2,3,4 to select an option, and based on his option I would develop the code further to do different things. Thanks!!

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Message box for selection!!

    Use an inputbox.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 365 on Win11 (desktop), 2019 on Win11 (notebook)
    Posts
    8,198

    Re: Message box for selection!!

    hI; jsuarez199;

    maybe like this:
    Please Login or Register  to view this content.
    IŽd go with a Userform and either a ComboBox or ListBox in there.

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  4. #4
    Registered User
    Join Date
    04-11-2013
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    92

    Re: Message box for selection!!

    Inputbox solved it. THANK YOUUU

+ 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. [SOLVED] Check box that pops a text box or message box upon selection
    By neo21384 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-07-2013, 01:18 PM
  2. Can a message box do a selection and take me to a sheet automatically
    By Hello23 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-22-2012, 03:09 PM
  3. multiple cell selection message box
    By sdts in forum Excel General
    Replies: 3
    Last Post: 06-21-2012, 08:18 AM
  4. Use VBA code to display message if combobox selection not in list
    By hurlbut777 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-29-2005, 07:40 PM
  5. Message - Selection contains empty cells
    By al007 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-28-2005, 07:10 AM

Tags for this Thread

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