Macro Dialog Box
 

Hi,
Is it possible to create a dialog box that would allow me to enter the
following information in and have it placed on each tab in a workbook?

Piece Name - Text Field
Year Made - text field
Edition - text field
Picture/File - browse button to find the file to create a hyper link and a
seperate option to have a screen tip
Status: dropdown
Notes: large text Field
Mold Y/N - Radio button
Location of Mold - Dropdown list

Macro Dialog Box
 

A UserForm, which can be created in the Visual Basic Editor, should solve
most of your problems. Text/numeric entries are easy to set up. The
browsing for the picture file reference to use as a hyperlink will be a touch
tricky - you'll need to code the use of

Application.FileDialog(msoFileDialogOpen)

to get the path to the file. Search Excel VB Help for FileDialog.
The UserForm itself will need some code to move the information from the
user form into the workbook.


"cardosol" wrote:

Hi,
Is it possible to create a dialog box that would allow me to enter the
following information in and have it placed on each tab in a workbook?

Piece Name - Text Field
Year Made - text field
Edition - text field
Picture/File - browse button to find the file to create a hyper link and a
seperate option to have a screen tip
Status: dropdown
Notes: large text Field
Mold Y/N - Radio button
Location of Mold - Dropdown list