VBA InputBox

Hi All,

I am facing problem in taking input from user with VBA InputBox:
1. I want to take input (Cross Rate) from the user.
2. The Cross Rates are
i. EUR/USD
ii. USD/JPY
iii. GBP/USD
iv. USD/CAD
v. AUD/USD
vi. USD/CHF
vii. USD/BDT
3. The Cross Rates are Numbers with decimals. For example: EUR/USD = 1.3475, USD/JPY = 89.57, GBP/USD = 1.5358, USD/CAD = 1.0559, AUD/USD = 0.8888, USD/CHF = 1.0857, USD/BDT = 69.63
4. At first, the user must be given the option whether he wants to input cross rate. If user chooses to input cross rate, an input box is to prompt to take user input.
5. If the user chooses Cancel Button of the input box, ask the user whether he wants to exit. If chooses to exit, EXIT SUB. If user chooses to continue, an input box is to prompt to take user input.
6. If user enters nothing (Zero lenth string) and/or chooses OK Button of the InputBox, Prompt user nothing is entered and prompt an input box to take user input
7. If user enters Other than Numbers, Prohibit user to input. Ask user to re-input Cross Rate (Numbers with decimals)
The above sequence must be present in taking input for each of the below cross rates:
i. EUR/USD
ii. USD/JPY
iii. GBP/USD
iv. USD/CAD
v. AUD/USD
vi. USD/CHF
vii. USD/BDT
8. After user inputs valid Cross Rate, input data in certain cells in two Workbooks. The first workbook contains the macro. The macro is to open the second workbook and paste the input into certain cells.
I am currently using the folllowing code. This would give you hint in what sequence the program is to run.

Please Login or Register  to view this content.

Rashed, code tags go into square brackets, like this [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code].

I'll correct it for you this time, but please try to remember. You can click the # icon in the editor to wrap code tags around your highlighted code.

From your code I would say it would be better to create a UserForm