Posted to microsoft.public.excel.programming

external usenet poster

Posts: 196

combobox

I am using Excel 97, I have an array in vba for the
dropdown.

If a user types something in the combobox which isn't in
the array, is there a way to check the array and if it
isn't listed to continue and change the entry of another
cell say?

Can someone help please?

Mark

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
fill combobox depending on selection from another combobox	Adam Francis	Excel Discussion (Misc queries)	2	July 24th 08 07:39 PM
ComboBox	Abs	Excel Discussion (Misc queries)	3	February 15th 06 02:05 AM
ComboBox	No Name	Excel Programming	2	June 10th 04 05:15 PM
Combobox	Francis Ang	Excel Programming	2	February 19th 04 05:31 AM
COMBOBOX	GREGORY	Excel Programming	1	December 4th 03 11:07 PM

All times are GMT +1. The time now is 12:57 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us