mayerc
01-02-2009, 05:05 AM
Hi all.
As part of my project I am allowing users to add comments about particular subjects. They click on a command button to add a comment and a userform 'CommentsAC' is shown.
The combobox is populated with a list from my worksheet with a named range. The user needs to select from this list the asset they want to comment upon. They can then add comments and click "Add Comments".
I am having issues unfortunately getting the comments added to populate the correct cell on the worksheet, as the cell will differ depending on which item is selected from the list.
The list items refer to labels on another userform called 'SkillsFom' so I thought that I could write the code to say if the combobox = the caption of a particular label then add text to a particular cell. But it doesn't work.
I have attached my project in thread "Populating text box in userform with Label Value" (http://www.vbaexpress.com/forum/showthread.php?t=24447) and any help would be greatly appreciated.
Thanks in advance.
Chris
Edit Lucas: Link added. Chris, when posting you can copy the url of the page where you want to link to and select the text in your post and hit the globe icon(insert link)
As part of my project I am allowing users to add comments about particular subjects. They click on a command button to add a comment and a userform 'CommentsAC' is shown.
The combobox is populated with a list from my worksheet with a named range. The user needs to select from this list the asset they want to comment upon. They can then add comments and click "Add Comments".
I am having issues unfortunately getting the comments added to populate the correct cell on the worksheet, as the cell will differ depending on which item is selected from the list.
The list items refer to labels on another userform called 'SkillsFom' so I thought that I could write the code to say if the combobox = the caption of a particular label then add text to a particular cell. But it doesn't work.
I have attached my project in thread "Populating text box in userform with Label Value" (http://www.vbaexpress.com/forum/showthread.php?t=24447) and any help would be greatly appreciated.
Thanks in advance.
Chris
Edit Lucas: Link added. Chris, when posting you can copy the url of the page where you want to link to and select the text in your post and hit the globe icon(insert link)