Sharid
Well-known Member
- Joined
- Apr 22, 2007
- Messages
- 1,064
- Office Version
- 2016
- Platform
- Windows
Is it possible to have a dynamic control source for a textbox?
In the example below, the userform has 7 pages. Each page has a command button to run the code and is linked to a separate sheet, however there is only 1 TEXTBOX to show results found. This will be triggered from each Sheets Change Events and record on that sheet.
I was thinking of doing it as such. However I am a bit stuck
is THIS POSSIBLE?
In the example below, the userform has 7 pages. Each page has a command button to run the code and is linked to a separate sheet, however there is only 1 TEXTBOX to show results found. This will be triggered from each Sheets Change Events and record on that sheet.
I was thinking of doing it as such. However I am a bit stuck
- Command button when clicked will place a number 1 to 7 in Sheet10 A1, depending on which multipage it is on.
- Each Sheet 1 to 7 will record its own results on Sheet change event in a cell e.g. Sheet1 A1, Sheet2 A1, Sheet3 A1
- The text box will have a if statement to state -
- If Sheet10 A1 = 1 then Control source is Sheet1 A1 End If
- If Sheet10 A1 = 2 then Control source is Sheet2 A1 End If
- If Sheet10 A1 = 3 then Control source is Sheet3 A1 End If
is THIS POSSIBLE?