Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
urgent VBA question
i have a form which i created using vb editor. How do i manipulate it so that while in run time a user will be able save the form on their c: drive. I am fairly new at using vba. I am more familiar with vb 6. I notice using vba i am not able to create a menu editor to accomplish saving, printing, editing.. I know i have to use the form as the interface but how do i transfer my codes i created on the form to the excel sheet. Can someone give me a step by step way of doing this. I would really appreciate some expert advise on this one -- dstyles782001 ------------------------------------------------------------------------ dstyles782001's Profile: http://www.excelforum.com/member.php...o&userid=31727 View this thread: http://www.excelforum.com/showthread...hreadid=515316 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
urgent VBA question
You have to do something like this to persist userform entries:
Sheet1.Range("a1").Value = _ TextBox1.Value -- Jim "dstyles782001" wrote in message news:dstyles782001.23mxbz_1140618602.1603@excelfor um-nospam.com... | | i have a form which i created using vb editor. How do i manipulate it | so that while in run time a user will be able save the form on their c: | drive. | I am fairly new at using vba. I am more familiar with vb 6. I notice | using vba i am not able to create a menu editor to accomplish saving, | printing, editing.. I know i have to use the form as the interface but | how do i transfer my codes i created on the form to the excel sheet. | Can someone give me a step by step way of doing this. | I would really appreciate some expert advise on this one | | | -- | dstyles782001 | ------------------------------------------------------------------------ | dstyles782001's Profile: http://www.excelforum.com/member.php...o&userid=31727 | View this thread: http://www.excelforum.com/showthread...hreadid=515316 | |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
urgent VBA question
Which also means that the next time you load the form, you have to reload
the data. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Jim Rech" wrote in message ... You have to do something like this to persist userform entries: Sheet1.Range("a1").Value = _ TextBox1.Value -- Jim "dstyles782001" wrote in message news:dstyles782001.23mxbz_1140618602.1603@excelfor um-nospam.com... | | i have a form which i created using vb editor. How do i manipulate it | so that while in run time a user will be able save the form on their c: | drive. | I am fairly new at using vba. I am more familiar with vb 6. I notice | using vba i am not able to create a menu editor to accomplish saving, | printing, editing.. I know i have to use the form as the interface but | how do i transfer my codes i created on the form to the excel sheet. | Can someone give me a step by step way of doing this. | I would really appreciate some expert advise on this one | | | -- | dstyles782001 | ------------------------------------------------------------------------ | dstyles782001's Profile: http://www.excelforum.com/member.php...o&userid=31727 | View this thread: http://www.excelforum.com/showthread...hreadid=515316 | |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
urgent VBA question
HI jim do i have to close out the form go back to the excel sheet and copy yr code to a cell -- dstyles782001 ------------------------------------------------------------------------ dstyles782001's Profile: http://www.excelforum.com/member.php...o&userid=31727 View this thread: http://www.excelforum.com/showthread...hreadid=515316 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
urgent VBA question
No, you should be able to do it in the form, such as in its terminate event.
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "dstyles782001" wrote in message news:dstyles782001.23ng2y_1140642903.4758@excelfor um-nospam.com... HI jim do i have to close out the form go back to the excel sheet and copy yr code to a cell -- dstyles782001 ------------------------------------------------------------------------ dstyles782001's Profile: http://www.excelforum.com/member.php...o&userid=31727 View this thread: http://www.excelforum.com/showthread...hreadid=515316 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
urgent VBA question
Private Sub UserForm_Initialize() ComboBox1.AddItem "New User Request" ComboBox1.AddItem "Change existing User" ComboBox2.AddItem "User" ComboBox2.AddItem "Enterprise" ComboBox2.AddItem "Full Access" ComboBox2.AddItem "Accounting - A" ComboBox2.AddItem "Accounting - B" ComboBox2.AddItem "Reporting Only" ComboBox3.AddItem "Pending" ComboBox3.AddItem "Completed" -- dstyles782001 ------------------------------------------------------------------------ dstyles782001's Profile: http://www.excelforum.com/member.php...o&userid=31727 View this thread: http://www.excelforum.com/showthread...hreadid=515316 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ANOTHER URGENT QUESTION - Sums and Ifs | Excel Worksheet Functions | |||
Urgent question regarding LIST | Excel Discussion (Misc queries) | |||
NEWSGROUP QUESTION URGENT | Excel Worksheet Functions | |||
Simple Question but need urgent help pls... | Excel Worksheet Functions | |||
validation question, urgent pls help | Excel Discussion (Misc queries) |