Re: [ExcelVBA] Input Box w/selection

 

Hi Guys

Oops. Your ideas are great. An I am working on it at the moment. Another learning curve.

Thanks

Charlie

From: Paul Vermeulen
Sent: Monday, June 20, 2011 2:19 PM
To: ExcelVBA@yahoogroups.com
Subject: RE: [ExcelVBA] Input Box w/selection

Hi Charlie

You have to split your problem into two, then the answer is simple.
First, design an input box in the VBE (Insert UserForm), type the
question into the Caption field, and insert a combo box from the
Toolbox, along with two CommandButtons (OK and Cancel buttons).

Now write your code to check whether something has been selected before
accepting OK, Cancel = End, give it a try and let us know how you get
on.

Regards

Paul

From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On
Behalf Of railroads@slingshot.co.nz
Sent: Saturday, 18 June 2011 4:17 PM
To: ExcelVBA@yahoogroups.com
Subject: [ExcelVBA] Input Box w/selection

Hi

I want to use a input box in some code. Would like, where the box asks
for user input, to have a drop down to select required input. Is this
possible with input box (like a combo)? if I use a combobox there is no
place to put the question.

Your comments appreciated.

Thanks

Charlie Harris

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (4)

Recent Activity:

• New Members 9

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___