ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   User_Form's Caller (https://www.excelbanter.com/excel-discussion-misc-queries/115368-user_forms-caller.html)

PerlDev

User_Form's Caller
 
I have User_Form A, B and C; Both A and B have button to make C show
up. When C is called, how to know it's called by either A or B?


Dave Peterson

User_Form's Caller
 
I'd declare a public variable in a General module and just keep track.

Public WhichCalled as String

then before you show C, you could use:

WhichCalled = "UserformA"



PerlDev wrote:

I have User_Form A, B and C; Both A and B have button to make C show
up. When C is called, how to know it's called by either A or B?


--

Dave Peterson


All times are GMT +1. The time now is 08:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com