Hi,
I have a UserForm opened vbModeless, would like to click on cell on worksheet and append content of cell to a textbox on the UserForm, how can I code this?
Thanks for any help
David
mdavid
If You have an Excel-file of this case
then You should upload even sample of it here.
It would be much 'easier' for You to try to use any solution.
Thanks for this Belleke,
My logic is a little different, I want first to click on a cell which will open the UserForm with the clicked cell content in a TextBox on the form, much as you've done. Then with the Form still open I want to be able to click on other cells on the sheet and append the content of those cells to the TextBox on the UserForm.