Macro Dialog Box

C

cardosol

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
 
J

JLatham

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Microsoft access database(creating a search engine form) 0
Macro I think???? 2
User Interface Basics -- Have we begun to regress? 1
How to create dialog box that will post to worksheet encoded data? 1
Combine text values from many records into a single textbox 2
Paste to Find dialog box using a macro 3
How to create a dialog box to encode information to worksheet? 2
Displaying Jpegs on form. 2

Top