Array of Textbox

[Rasm]

Parry - or anybody else
I did search - found this - Can you tell me how to insert i.e. a Listbox right onto the worksheet - using code. I would like to see it both as a Form control as well as an ActiveX control - I like the Form control as it has the OnAction property - that allow me to add the control at run time and have the event code in my module. However I like working with ActiveX better. So if the control and be ActiveX and the event flag for that control resides in a module - that would be perfect. Hope you can help

 

[boblarson]

Re: array of textbox

RASM since you said "onto the worksheet" then isn't this an Excel question and not an Access question and it should be in the Excel area instead of Access?

 

[Rasm]

Re: array of textbox

ohhh - yes - I did not realize it was Access - I did a search and this came up - you are right.

 

[Norie]

Re: array of textbox

Rasm

I agree with Bob, this should be in the Excel forum - you can contact an admin for that.

As for your question, I don't really understand what you want to do.

You can't use an ActiveX control as a Forms control and vice versa.

Also, why do you want to add the control at runtime?

 

[Joe4]

Split from this original post in the Access forum:
http://www.mrexcel.com/forum/showthread.php?t=353584