Hello everyone,
Am looking for a solution to the following problem in Excel VBA.
How can I program cq code the following formula and assign that code to a commandbutton (Calculate) on a userform ?
The formula is 1/SQRT(24)*10
(24) is a value from a combobox (Scale) on the same userform and 10 is a value from a textbox (Ship speed) on that userform.
I would like to have the result of the calculation shown in yet another textbox (Model ship speed) on that userform.
2,04 is the correct answer but I can't get it in that textbox through programming.
Any suggestions are more than welcome as it has me flabbergasted.
Thanks in advance,
Dirk Smit
[ATTACH]userform.jpg[/ATTACH]
Bookmarks