VBA , list selector, alternative solution.

[martin81]

Hello,

Please,

I have "list selector", screen and test workbook added. And I want to ask for this:
**************************************************

1) Please , exist some way how do to do larger latters inside?

2) If not, exist some alternative what I can use as "list selector"?

3) Please, what is way how I can have selected lettr in "A1" ? Because I have there numbers only.

Thank you in advance for some answer.

Best Regards
Martin
list_selector.jpg

[mehmetcik]

1) Please , exist some way how do to do larger latters inside? No.

2) If not, exist some alternative what I can use as "list selector"? Yes use a userform. I will create one for you.

3) Please, what is way how I can have selected letter in "A1" ? Because I have there numbers only. The Drop Down Box is telling you that you picked the third item.


Ok we have a solution.

1. Click in Cell A1 will run this Macro:-

Please Login or Register  to view this content.

To edit this Macro, Right Click on the sheet name at the bottom of excel and select view code.

The Macro Opens a Userform that only has a list box and a close button ( Top Right )

I have loaded the Userform with these Macros.

Please Login or Register  to view this content.

[martin81]

Thank you a lot for answers! I will try your userform.

[martin81]

WOW!!!

It works!

Thank you a lot! Perfectly!

And thank you for explain how I can go for code in workbook - good detail Because it was first what I did not know how

This thread can be marked as solved.

Regards

Thx

Martin