I have a survey application. Questions and the previously saved answers are displayed in a list box. I want to allow the user to change the answer. basically, need an editable column of a list box. listbox has column count 2 and i want the 2nd column to be made editable. Any help please ?
You can't edit directly in the listbox.
Where is it located?
If it's on a userform you could have 2 textboxes that could be populated when the user selects a row in the listbox.
They can change the values in the textboxes and then click an update button to make the required changes in the listbox.
If posting code please use code tags, see here.
Thanks for the quick reponse.
1) The list box is located in a userform
2) I need a list box because, the administrator should be able to include or remove questions. hence set the rowsource of the listbox to a range in the worksheet
3) having textboxes, i am afraid would impact usability for the end user. there are about 30 questions. so, first time user have to select the question, enter answer and click on update for every question
4) I am not very fixed to the listbox solution, If i can dynamically load labels and combo boxes in a multipage of an user form. Questions are categorised into 3 segments.
What exactly are you looking for?
A userform to allow the user to answer the questions?
If it's not that how are the users answering the questions?
Also, why would a listbox mean having to select and answer every question?
yes, a user form to allow the user to answer and modify answers to questions
I meant, I was not for the idea of clicking on an item in list box, having the data loaded in text / combo boxes and allow user make change and save it back to list. Sorry, that is what i understood by your statement
"If it's on a userform you could have 2 textboxes that could be populated when the user selects a row in the listbox."
If you had a multipage and comboboxes then the user would have to click through the pages, select from the comboboxes etc.
If it's only the answers you want the user to enter all you need is a listbox for the questions, a textbox (combobox?) for the answers and a command button.
The user selects the question, if there is an existing answer is loaded in the textbox where it can be changed, if there isn't an existing answer the user enters their answer.
To commit the answer/update answer the user clicks the button.
Thanks. what is your suggestion on the number of text boxes ? As many as there are questions ?
No, one textbox where the user can enter the answer to the currently selected question in the listbox.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks