VBA and validation list

Posted to microsoft.public.excel.programming

John

external usenet poster

Posts: 2,069

VBA and validation list

Hi,

I have a validation list (H1:H5), I hope, using VBA, the list can
automatically attach itself to any cell in the first column of the worksheet
when the cell gets input focus.

How can I do this?

Thanks.

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
data validation invalid in dynamic validation list	ilia	Excel Discussion (Misc queries)	0	November 7th 06 12:54 PM
data validation invalid in dynamic validation list	ilia	Excel Worksheet Functions	0	November 7th 06 12:54 PM
Validation (Drop down list vs simple text length validation)	Bob Phillips[_6_]	Excel Programming	2	April 27th 04 07:47 PM
Validation (Drop down list vs simple text length validation)	Jason Morin[_2_]	Excel Programming	1	April 27th 04 04:56 PM
Validation (Drop down list vs simple text length validation)	Pete McCosh	Excel Programming	0	April 27th 04 03:49 PM

All times are GMT +1. The time now is 11:52 PM.

Menu

About Us