Window with selection rollbar

jfdallard · January 12, 2018, 7:30am

Hello

I'm looking for a SW macro that brings up a selection rollbar so that the user can make a choice (of the language in this case fr, gb, esp) and that it launches different parts of my macro with an if I guess.

Thank you for your help

d.roger · January 12, 2018, 8:29am

Hello

Wouldn't it be a Combobox you're looking for?

See http://silkyroad.developpez.com/VBA/ControlesUserForm/#LII-F

Kind regards

jfdallard · January 12, 2018, 8:50am

Yes if rather and when I select my language it sends me back to my if "French" then.

Thank you for your help d.roger

Kind regards

d.roger · January 12, 2018, 10:21am

Here is a small example of a macro that allows, by code, to fill a combobox and then display a message when selecting a value from the list.

Kind regards

macrocombobox.swp

jfdallard · January 16, 2018, 7:37am

Thank you again d.roger for your help. I looked at the combobox but unfortunately it exceeds my technical skills, I have to give up due to lack of time...