forms in excel

  • Thread starter Thread starter Scott
  • Start date Start date
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.
 
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
 
Actually you explained it very well. That is exactly what I needed to know.
Thanks dude!!!
 
Back
Top