LisBox - UserForm

[poleary2000]

All,

Is there anyway to set a variable equal to the Control Source in a list box contained on a user form? I've had it link to a cell but never to a variable. I need it to link to a variable because it could reference multiple sheets.

 

[poleary2000]

Any suggestions.

 

[brettvba]

Don't think so I think If you created an object you might be able to but I'm not sure how to go about it try reading the help file on Controlsource

 

[Ivan F Moala]

On 2002-04-08 19:09, poleary2000 wrote:
All,

Is there anyway to set a variable equal to the Control Source in a list box contained on a user form? I've had it link to a cell but never to a variable. I need it to link to a variable because it could reference multiple sheets.

Try
<Pre/>
Dim MyVar

MyVar = Me.ListBox1.ControlSource
MsgBox MyVar

</pre>

 

[poleary2000]

Thanks!