possible if function??
You may want to consider using a UserForm to collect all this data.
You can use a ComboBox for "What is the HFC MAC?" which allows the user
to choose from a predefined list (based on previously entered data) or
enables a textbox for entry if "Other..." is selected in the Combo.
ComboBoxes may also be suitable for your other fields.
For your existing code, you may consider revising the input prompts to;
while entry2 = ""
entry2 = InputBox "What kind of modem is it?"
wend
and so on for the other inputs
(I think my while/wend syntax is correct) This will avoid dumping the
user out of the procedure if they double press ENTER and inadvertantly
send an empty string.
|