This is a simple question but I just cant get the right format. I have a userform which saves info entered into the form into a worksheet. I have one cell in anoth worksheet (sheet2) which I would like include in the info from the form.
I already have the column entered in the database I am now trying to figure out how to include this in the save.
I would need to identify this cell in my VBA.
DIM "cell" as ?
Any help would be greatly appreciated.
Last edited by jcarstens; 08-20-2009 at 02:41 PM.
Hello jcarstens,
You would delcare it as a Range object type.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Then if my cell is in sheet 2, cell B:2
How do I define that range.
Thank you
As Leith says
Please Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Perfect, Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks