I am trying to build a task check list check with a couple of “intelligent cells.
Below is a screenshot of the spreadsheet.
As you can see below, I have created a a button that lives in column E for each row.
The basic button, which is in E2, calls “Button6_Click” (code below), and basically does what I want it to. There may be an easier way (and am willing to be shown how), but I have grabbed the user name and input it into column “C” of the same row, and put the date/time stamp in column ‘D” of the same row.
I have another button, called “Button86_Click”. I have it called from column E for the rows that required “data”, in column “B”. Primarily I have not allowed the button to autofill the user name and date int columns “C” and “D” respectively if the “data” cell is blank. That appears to work. What I also need to do is blank out the username and date in the columns “C” and “D” if the user makes any change or totally deletes the value in the data column “B”.
I am sure there is probably a way to also combine both of my code segments below to a procedure call, which could then be called by each button click, since they basically do the same thing, except for needing to determine if there is any data in the “C” column for the respective row.
Thanks in advance for any help.
...
[attach]excel ss.PNG[/attach]
screen image of worksheet here:(this did not appear work for some reason, and I have attached a word doc with question that also contains the screen shot of my worksheet
…………………………………………
…………………………………………..
………………………………………….
Bookmarks