Pop uP with input options

[ogo]

Hi All,

Is there any way to create a pop up box with some options and user can select particular option and depending on the option selected call different functions??

 

[Ralajer]

ogo,

Yes, you could do what your asking with a VBA UserForm. Search around for some UserForm tutorials. The process to make one isn't that hard but it difficult to explain using text only.

 

[patu123]

Thanks Rob, I will try my luck but even if I can get some kind of headsup and can an rough idea would be very helpful!!!

Patel

 

[ogo]

Hello guys,

I used commandbars.showpopup method.
Some data is available at http://www.mrexcel.com/forum/showthread.php?p=2739141#post2739141

and a complete example at http://www.rondebruin.nl/popup.htm

this is working fine..