Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Forms in Excel | Excel Discussion (Misc queries) | |||
Using forms In excel | Excel Discussion (Misc queries) | |||
forms in excel | Excel Worksheet Functions | |||
forms in excel | Excel Programming | |||
excel forms | Excel Programming |