try this....
' before copy paste this code you must draw a textbox a label and a commond
button.
Dim rw As Integer, cl As String
Private Sub CommandButton1_Click()
TextBox1.ControlSource = cl & rw
Label1.Caption = cl & rw
rw = rw + 1
End Sub
Private Sub UserForm_Activate()
rw = 1
cl = "A"
End Sub
Private Sub UserForm_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
cl = InputBox("Please enter column lable. i.e A, B, C... ")
rw = InputBox("Please enter row number. i.e 1, 2, 3... ")
TextBox1.ControlSource = cl & rw
End Sub
regarding using show/hide, load/unload i would prefer to use show/hide if i
want to use form again n again because i stay in memory otherwise
load/unload save momery ......
hope you will get better solution ....
regards,
Stay Smart
On 8/23/08, jamesdavey <[EMAIL PROTECTED]> wrote:
>
>
> so to start with you use.... Form.Show
>
> Then on the form you have an "ok" button. When this button is pressed
> you write some code to hide the form (not unload), then when you show
> the form again, you reset the values you want to and leave the ones
> you don't
>
> >
>
--
Stay Beautiful, Always.
Abdul Salam
Accounts Officer
Elysium Holdings Pakistan Ltd.
(:+92-321-5001- 361
* [EMAIL PROTECTED]
P Save a tree...please don't print this e-mail unless you really need to
--~--~---------~--~----~------------~-------~--~----~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~----------~----~----~----~------~----~------~--~---
