ListBox - Form vs ActiveX

I have a dilemma - I need a list box that outputs the number of its selection, and can be toggled visible/not visible.

The Form Control ListBox outputs the number of the option selected (In a list of states, selecting "Alaska" returns "2"). However, I cannot seem to make my CommandButton toggle its visibility.

The ActiveX Control ListBox outputs the selection itself (Selecting Alaska returns"Alaska") and I cannot seem to run formulas based on it (=(A1="Alaska") returns FALSE instead of TRUE). I can, however, toggle its visibility with a command button:

Please Login or Register  to view this content.

I tried that code with a Form ListBox (I determined its name by assigning it a macro). "ListBox3.Visible = True" results in an error: Run-time error '424': Object required.

So - I need one of the following (although learning them all is always awesome, too):

- A way to make my ActiveX control output the number of its selection

- A formula that can take the ActiveX selection into account (a boolean on the "State" selected)

- Or a way to modify my above code to toggle the visibility of a Form ListBox

Thoughts?

Hi, and welcome to the board. Do you mean something like this one????
Pls see attached

Bump 10char

Edit: I cross-posted my question to the thread below after I bumped this thread.

http://www.mrexcel.com/forum/showthr...=1#post2557153

Second Edit: Was then subsequently solved at the cross-posted forum.

Solution was provided to toggle Forms ListBox using:

Please Login or Register  to view this content.

.

And also cross-posted here.

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

Read this to understand why we ask you to do this