Passing value between Command Button and Form

[nivassrii]

Dear Friends,

I am Using a Command button in my Spread sheet through which I ll be getting a value to variable " I ". I want to pass this value of " I " to a userform created in the same sheet.

Can somebody suggest me how to perform this.

Thanks.

[tigeravatar]

nivassrii,

I'd recommend using a public variable. To declare a public variable, at the top of a standard module, type:

Public I as String

If I is a different kind of variable, just change the type from String to whatever it needs to be. Then you can just reference I in subroutines and userforms.

Hope this helps,
~tigeravatar

[nivassrii]

tigeravatar,

The Idea is not working. Can you please check with my Spread Sheet attached here.

[Andy Pope]

Once you show the userform modal the code lines following the show method will not execute until the userform is unloaded or hidden.

Instead execute the commands before showing. No need for public variable.

Private Sub cmdPettyCash_Click()
I = 11
Do Until Cells(I, "B").Value = ""
I = I + 1
Loop


frmPettyCash.txtSerial.Enabled = False
frmPettyCash.txtSerial.Value = I - 9
frmPettyCash.Show

End Sub

[nivassrii]

Thank you its working..