LisBox - UserForm

poleary2000 · Apr 8th, 2002, 08:09 PM

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 · Apr 8th, 2002, 09:50 PM

Any suggestions.

brettvba · Apr 8th, 2002, 10:05 PM

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 · Apr 8th, 2002, 10:11 PM

Quote:

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



Dim MyVar



MyVar = Me.ListBox1.ControlSource

MsgBox MyVar

poleary2000 · Apr 9th, 2002, 06:58 AM

Thanks!

Apr 8th, 2002, 08:09 PM	#1
poleary2000 Board Regular Join Date: Apr 2002 Location: Pittsburgh, PA Posts: 317	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. __________________ Thanks in advance, Patrick

Apr 8th, 2002, 09:50 PM	#2
poleary2000 Board Regular Join Date: Apr 2002 Location: Pittsburgh, PA Posts: 317	Any suggestions. __________________ Thanks in advance, Patrick

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 8th, 2002, 10:05 PM	#3
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	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

Apr 9th, 2002, 06:58 AM	#5
poleary2000 Board Regular Join Date: Apr 2002 Location: Pittsburgh, PA Posts: 317	Thanks!