W Wackedmac Registered User. Local time Today, 15:13 Joined Jul 15, 2002 Messages 10 Jul 15, 2002 #1 How do I put the textvalue of a combobox in a variable, not the number but the actual text that u can select. thanks for ur help
How do I put the textvalue of a combobox in a variable, not the number but the actual text that u can select. thanks for ur help
Howlsta Vampire Slayer Local time Today, 15:13 Joined Jul 18, 2001 Messages 180 Jul 15, 2002 #2 yourcombo.column(1) is what you want, if you only have one column visible. VBA automatically takes the number (.column(0)) if you don't specify the column. HTH Rich
yourcombo.column(1) is what you want, if you only have one column visible. VBA automatically takes the number (.column(0)) if you don't specify the column. HTH Rich
