asked on

VBA code help for multiplying values

Hello all,

I need help with two sets of code as I am undecided which option to go with yet.

First code - If I enter a value into text box "txt_cb_two_enter" then the text box "text_cb_two_result" displays the value from "txt_cb_two_enter" mutiplied by 500. So 1 is entered in the first box and 500 is displayed in the second box.

Second code - If I enter a value into text box "txt_cb_two" then the value is mutiplied by 500 and the result is displayed in the same text box but as currency. So 1 is entered in the box and £500 is displayed.

Thanks in advance.

Chris

ASKER CERTIFIED SOLUTION

Rey Obrero (Capricorn1)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

MINDSUPERB

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Rey Obrero (Capricorn1)

no need to use two textboxes, one will do.

smods

ASKER

Yeah thanks both for your input!

I haven't decided on my final approach for the job in hand yet capricorn1.

My users may want to go with two boxes so they can see the initial value they have entered. If I was to go with a single box approach what would the code be to change the field type to currency from a number?

Regards

Chris

Rey Obrero (Capricorn1)

just set the format of the textbox to currency

smods

ASKER

I'm still not sure which I'll be going with but both work :)

Thanks

Chris