Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding Sheet Controls
Hi all, I am querying my excel data to product x amount of rows, is it possible to add a combo box in col E for each row of data obtained - using VBA? Thanks all! -- gti_jobert ------------------------------------------------------------------------ gti_jobert's Profile: http://www.excelforum.com/member.php...o&userid=30634 View this thread: http://www.excelforum.com/showthread...hreadid=537984 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding Sheet Controls
Sounds like you want Data Validation. See
http://www.contextures.com/xlDataVal01.html -- HTH Bob Phillips (remove nothere from email address if mailing direct) "gti_jobert" wrote in message ... Hi all, I am querying my excel data to product x amount of rows, is it possible to add a combo box in col E for each row of data obtained - using VBA? Thanks all! -- gti_jobert ------------------------------------------------------------------------ gti_jobert's Profile: http://www.excelforum.com/member.php...o&userid=30634 View this thread: http://www.excelforum.com/showthread...hreadid=537984 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding Sheet Controls
Hi Bob.....thanks for reply! I have now added validation to those cells, but now want a DateControl added to another cell range. I know data validation can do something with dates but a calendar would be alot better. I've come accross this doc: http://msdn2.microsoft.com/en-us/library/4za48s1h.aspx But cant seem to get it working! Any other ideas or help appreciated. -- gti_jobert ------------------------------------------------------------------------ gti_jobert's Profile: http://www.excelforum.com/member.php...o&userid=30634 View this thread: http://www.excelforum.com/showthread...hreadid=537984 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding Sheet Controls
For a calendar, see http://www.rondebruin.nl/calendar.htm
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "gti_jobert" wrote in message ... Hi Bob.....thanks for reply! I have now added validation to those cells, but now want a DateControl added to another cell range. I know data validation can do something with dates but a calendar would be alot better. I've come accross this doc: http://msdn2.microsoft.com/en-us/library/4za48s1h.aspx But cant seem to get it working! Any other ideas or help appreciated. -- gti_jobert ------------------------------------------------------------------------ gti_jobert's Profile: http://www.excelforum.com/member.php...o&userid=30634 View this thread: http://www.excelforum.com/showthread...hreadid=537984 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding Controls in a toolbar? | Excel Programming | |||
adding controls to userform at runtime | Excel Programming | |||
Adding controls to userform | Excel Programming | |||
Progmatically adding controls in multipage | Excel Programming | |||
Help with adding controls | Excel Programming |