urgent VBA question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dstyles782001 - 22 Feb 2006 14:28 GMT

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

Signature

dstyles782001

Reply to this Message

Jim Rech - 22 Feb 2006 14:50 GMT

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

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

Signature

Jim

|
| i have a form which i created using vb editor. How do i manipulate it
[quoted text clipped - 6 lines]
| Can someone give me a step by step way of doing this.
| I would really appreciate some expert advise on this one

Reply to this Message

Bob Phillips - 22 Feb 2006 15:05 GMT

Which also means that the next time you load the form, you have to reload
the data.

Signature

HTH

Bob Phillips

(remove nothere from email address if mailing direct)

> You have to do something like this to persist userform entries:
>
[quoted text clipped - 13 lines]
> http://www.excelforum.com/member.php?action=getinfo&userid=31727
> | View this thread: http://www.excelforum.com/showthread.php?threadid=515316

Reply to this Message

dstyles782001 - 22 Feb 2006 21:12 GMT

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

Signature

dstyles782001

Reply to this Message

Bob Phillips - 23 Feb 2006 08:25 GMT

No, you should be able to do it in the form, such as in its terminate event.

Signature

HTH

Bob Phillips

(remove nothere from email address if mailing direct)

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

Reply to this Message

dstyles782001 - 23 Feb 2006 15:54 GMT

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"

Signature

dstyles782001

Reply to this Message