VBA: an input box with multiple entries?
Thomas.C
-
le père -
le père -
Hello everyone,
After a month of reading tutorials.. I’m starting to have fun with VBA and it’s partly thanks to you. Thank you.
I’m posting now for the following reason:
- I’m trying to create a form with multiple inputs aimed at filling a database of contributors (Last name, first name, address…). For now, my macro doesn’t satisfy me because it consists of a succession of basic InputBoxes like this:
Dim LASTNAME, FIRSTNAME as string
LASTNAME = InputBox "Please enter the contributor's last name"
ActiveCell.Offset(0, 1).Value = LASTNAME
FIRSTNAME = InputBox "Please enter the contributor's first name"
ActiveCell.Offset(0, 1).Value = FIRSTNAME
…
I would like to know if there’s a possibility of having a multi-entry INPUTBOX? If not, is there another object that can do this (userforms are not practical for me since the data will be stored in spreadsheet cells…)?
In short, the ideal would be to format a UserForm with the benefits of InputBoxes (i.e., storing the entered data in variables)
Thank you for your responses.
Best regards.
Thomas.
After a month of reading tutorials.. I’m starting to have fun with VBA and it’s partly thanks to you. Thank you.
I’m posting now for the following reason:
- I’m trying to create a form with multiple inputs aimed at filling a database of contributors (Last name, first name, address…). For now, my macro doesn’t satisfy me because it consists of a succession of basic InputBoxes like this:
Dim LASTNAME, FIRSTNAME as string
LASTNAME = InputBox "Please enter the contributor's last name"
ActiveCell.Offset(0, 1).Value = LASTNAME
FIRSTNAME = InputBox "Please enter the contributor's first name"
ActiveCell.Offset(0, 1).Value = FIRSTNAME
…
I would like to know if there’s a possibility of having a multi-entry INPUTBOX? If not, is there another object that can do this (userforms are not practical for me since the data will be stored in spreadsheet cells…)?
In short, the ideal would be to format a UserForm with the benefits of InputBoxes (i.e., storing the entered data in variables)
Thank you for your responses.
Best regards.
Thomas.
Configuration: Windows XP Firefox 1.5
Actually, I don't know how to program the values present in a combobox.
In other words, I know how to create a UserForm, I know how to associate it with an interactive button, and I know how to store the entered elements in a variable, but my comboboxes fetch their values (e.g., N°1, N°2... for the "Version No" combobox) from cells on an EXCEL sheet!
Do you have a solution for this?
Best regards and thank you again
T.C