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

You have to do something like this to persist userform entries:

Sheet1.Range("a1").Value = _
TextBox1.Value


--
Jim
"dstyles782001" <[email protected]>
wrote in message
news:[email protected]...
|
| 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
|

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" <[email protected]> wrote in message
news:[email protected]...
> You have to do something like this to persist userform entries:
>
> Sheet1.Range("a1").Value = _
> TextBox1.Value
>
>
> --
> Jim
> "dstyles782001"
<[email protected]>
> wrote in message
> news:[email protected]...
> |
> | 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
> |
>
>

HI jim do i have to close out the form go back to the excel sheet and copy yr code to a cell

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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

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"