Excel/VBA Common Input Dialogs

[btorrean]

Does anyone know of any Excel Add-Ins, or the like, that supply common user input dialogs? I used to program in Avenue for ArcView (ESRI) and, though the language itself was cumbersome, it had some really cool standard input dialogs that could be called. Some examples of those were combobox dialogs, listbox dialogs and multilistbox dialogs. All had Ok and Cancel buttons and were called just like MsgBox dialogs are called in VBA. I know these wouldn't be too difficult to create in VBA, but I thought I would check to see if anyone knew of anything that was already out there. Anyone?

Brian

Brian J. Torreano

 

[JLGWhiz]

The only ready-made user input tools are the InputBox and the Application.InputBox. One is treated as a property and the other as a function. You can get details for these in the VBA help files. Outside of those two, you would have to create your own with the UserForm facility provided in VBA. You can tailor make your own form to do inputs and manipulate data and it is called with the Show keywork, eg. 'UserForm1.Show' and then 'Unload UserForm1' to close it. Plenty of tutorials on the web for UserForm construction and use.

 

[btorrean]

JLGWhiz,

Thanks for the info. I thought I might just have to go ahead and make the forms, but was hoping there was something out there already. Thanks for the tips!

Brian

Brian J. Torreano

 

[JLGWhiz]

JLGWhiz,

Thanks for the info. I thought I might just have to go ahead and make the forms, but was hoping there was something out there already. Thanks for the tips!

Brian

Brian J. Torreano

Most of the Excel ready-made stuff is what you can find on the ribbon and in the menus and tool boxes. There is a lot that you can do with what is already available if you have the expertise to put it together. Most people never really take the time to learn what facilities Excel really has.
Regards, JLG