forms in excel

S

Scott

I am working with a spreadsheet that a customer developed and I am not sure
how to gain access to a popup box that is used.

Basically this is the code:
============================
Sub Quest6()

Range("aa1") = Range("A17")
Range("ab1") = Range("B17")
Sheets("Recommendations").Select
Recommendation_Form.Show

End Sub
=============================

The line: Recommendation_Form.Show is what bring this pop up screen. I'd
like to modify it but I am not sure how to pull it up or reference it in any
way. Any advise would be helpfull. Thanks.
 
R

RADO

Scott,

you need to open visual basic editor, turn on project
explorer (see menu "View"), and find the form among the
file objects (it should be named "Recommendation_Form").

Then you can modify the form by using form editor, or view
it code (double click on the form). I would advice you to
get a book on the topic, it's hard to explain in a few
words.

Best -
RADO
 
S

Scott N. Weber

Actually you explained it very well. That is exactly what I needed to know.
Thanks dude!!!
 
Top