Userform Textbox to show a value based on a referenced cell

[paradoxofthecat]

Hello,

I have a excel-userform with two sheets Test (2) and Test (3). What I'm trying to achieve and having a problem is at Step 3 of the sequence below.

1. Click "Create Adjustment" button

2. Select any amount from the radio button.

3. ~~~~What I would like to have is that when the "Adjustment" userform is displayed, the AmountTextBox must display the value referenced in Cell A6 respectively for each sheet. 5000 for Test(2) and 9000 for Test(3)

I do believe that editing the Controlsourceproperty is not sufficient for this task. Help please!

[xladept]

Maybe:

Please Login or Register  to view this content.

[protonLeah]

Please Login or Register  to view this content.

[paradoxofthecat]

Hi, Thank you for the replies, but the amounts of 5000 and 9000 are being combined in the text box showing as "5000 9000"

Would it be possible that for sheet Test (2) the amount being displayed is 5000 and for Test (3) its 9000? I'm planning on adding up to 20 sheets with the same naming order and each will have different amount per sheet.

[xladept]

Maybe:

Please Login or Register  to view this content.

With this event in the ThisWorkbook module:

Please Login or Register  to view this content.