Hello all, and thank you for all the help you've given me, even though most
it has been just looking through the archives! I'm still working on
shortening my learning curve. I haven't been able to find a clear-cut answer
on how I might be able to edit a comment from a UserForm, and I was hoping
someone could help me with that. I have a workbook that contains data on over
100 items that need to be adjusted occasionally after the preliminary work is
done (that's why they call it preliminary I guess). Because there are so many
worksheets I've created a UserForm that I can use to scroll through each page
and look at only the relavent data as I go. In addition, there is a macro I
run that loops through each sheet pulling a couple of points of data and
inserting into a comment box on a specified cell each month. Occasionally I
need to edit that comment and it would be nice if I could do so without
closing the UserForm, either by clicking a command button that would bring up
what was already there then I could modify it and save it back to the
worksheet, or through a textbox. Is this possible? I would really appreciate
any help you can give me.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200809/1