Userform

[mrdoctor]

I have the following worksheet
AGE A80A PPSP QTRLY MTHLY
64 34.56 46.78 64.89 45.00
65 73.45 25.56 33.98 56.87


I have created a userform with 2 comboboxes 1 combobox selects state(it is working) 2nd combobox selects age(iti is working) right now I have 5 txtboxes that contain the dollar amounts from a80 - mthly
If i select a state and select a age it populates the 5 txtboxes with a80a through mthly dollars what I am trying to do with no SUCCESS is IF I SELECT A STATE AND A AGE I WOULD LIKE TO BE ABLE TO USE 1 TXTBOX THAT WOULD PLACE THE DATA FROM A80A THROUGH MTHLY ON THE SELECTION AND HAVE THAT HEADER APPEAR.

EXAMPLE STATE = ILLINOIS AND AGE = 64 PAYCODE = A80A GIVE ME THE DOLLAR AMOUNT FOR THAT CASE IN 1 TXTBOX AND HAVE THE HEADING APPEAR AS A80A
IF I SELECT ILLINOIS AND AGE = 65 AND PAYCODE = MTHLY I WANT THAT DOLLAR AMOUNT TO APPEAR IN THE 1 TXTBOX AND HAVE THE HEADING APPEAR AS MTHLY


I HAVE TRIED EVERYTHING I KNOW(JUST BEGINING VBA) AND CAN NOT FIGURE A WAY TO DO THIS
HERE IS MY CODE SO FAR

Please Login or Register  to view this content.

THANKS GUYS

[JieJenn]

Can you post a simple workbook? And tag your code with (Without the space_

[ code ]
your code here ...
and here ...
and here
[/code]

[mrdoctor]

Bump no response

[royUK]

Bump no response

Add the code tags



Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here