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

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

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

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