R
Robert Belforti
Hello
I'm new to using forms. What I would like to do is have a
number of listboxes where the user selects one of the
items. I would then like these selected values to be
written as records in another sheet. So for example the
user has a listbox for fruit and the selections are
apples, oranges, pairs. The first time the user selects
pair. I would then want him/her to click a button that
would write this value to Sheet 2 Cell A2. The next user
selects apple. I would then want Apple to be written to
Sheet 2 Cell A3 and so on. Any ideas????
I'm new to using forms. What I would like to do is have a
number of listboxes where the user selects one of the
items. I would then like these selected values to be
written as records in another sheet. So for example the
user has a listbox for fruit and the selections are
apples, oranges, pairs. The first time the user selects
pair. I would then want him/her to click a button that
would write this value to Sheet 2 Cell A2. The next user
selects apple. I would then want Apple to be written to
Sheet 2 Cell A3 and so on. Any ideas????