forms in excel
 

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.

forms in excel
 

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.


.

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.


.