Hi All,
I have a VBA program that runs through excel. The program takes information from a vba form stores it to a database with a copy on a row in an excel sheet. When data from that row is modified I need a cell on that row to mark the row for updating.
I've attached a sample of the sheet layout.
Row.jpg
If Items/Cost/Retail changes the Sync Row needs to be updated to Yes.
Any insight is appreciated.
Thank you!
Last edited by jay_610; 03-07-2015 at 11:31 AM.
Please Login or Register to view this content.
How can this be linked to the excel sheet?
- Press Alt+F11 to open the VBA editor.
- On the left hand side of the editor is the Project explorer.
- Find your workbook name, then expand the Object folder to view the sheet objects.
- Double click the sheet name that you want the code to run on (Sheet1 or whatever).
- Paste the code in the white space to the right.
- The code will now run automatically. You don't need to keep the VBA editor window open.
That's awesome! Thanks Bro!
Glad to help! Please mark this thread as SOLVED (instructions below). And any reputation points (the star in the lower left of my posts) is appreciated.
To mark solved:
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks