Adding Sheet Controls

[gti_jobert]

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?

I've tried this;

Please Login or Register  to view this content.

But how do I put the control into a fixed cell?


Thanks all!

[Bob Phillips]

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[gti_jobert]

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.

[Bob Phillips]

For a calendar, see http://www.rondebruin.nl/calendar.htm

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"gti_jobert" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>