Thread: forms in excel
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Scott N. Weber Scott N. Weber is offline
external usenet poster
 
Posts: 1
Default forms in excel

Actually you explained it very well. That is exactly what I needed to know.
Thanks dude!!!
--
Scott N. Weber, MCP
http://www.AccessYourBiz.Com
Customizable Accounting Software
Written with Microsoft Access

"RADO" wrote in message
...
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


-----Original Message-----
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 N. Weber, MCP
www.AccessYourBiz.Com
Customizable Accounting Software
Written with Microsoft Access.


.