Passing value between Command Button and Form

**nivassrii** · 05-27-2011, 08:24 AM

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** · 05-27-2011, 10:40 AM

nivassrii,

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

Please Login or Register  to view this content.

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** · 05-28-2011, 03:21 AM

tigeravatar,

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

**Andy Pope** · 05-28-2011, 06:09 AM

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.

Please Login or Register  to view this content.

**nivassrii** · 05-30-2011, 12:21 AM

Thank you its working..

Passing value between Command Button and Form

LinkBack

Thread Tools

Rate This Thread

Display

Passing value between Command Button and Form

Re: Passing value between Command Button and Form

Re: Passing value between Command Button and Form

Re: Passing value between Command Button and Form

Re: Passing value between Command Button and Form

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions