Hello everyone!
I'm entirely new to excel, but can make common sense out of some code. That being said, I still have no idea what I'm doing because I don't know the "action" commands. I've attached the excel spreadsheet I've been working on, with some help from folks here as well.
I've only got one VBA code included and that is to require comments on certain values from drop down lists. Now onto my issues:
- There are vertical dashed lines going through the middle of my data bar cells in columns C, D, E, F. I've read it has something to do with conditional formatting and copying and pasting, but those weren't copy/pasted. How can I fix that?
- The data bars in columns C, D, E, F are also looking funny. some show full bars in the cell, and others with the same value do not. How can I fix that?
- When I add cells/checkboxes or other misc things to the work sheet, I get a run time 103 error. I have attached the VBA debug screen shot. Any idea why to get me heading in the right direction?
- On the VBA code for requiring comments I currently have inserted, when it puts in a comment I used Application.UserName to identify who made the change. How do I make that look more like the original excel method of identifying comment author?
- And lastly, how do I use an if-then statement on the checkboxes like I did with certain values from the dropdown list to require a comment when box is checked? I would like a "two-stage" comment insert. I want it to automatically insert the Date and Time it was checked, and then ask for text input for 'Reason'.
Thanks in advance for your help! I definitely couldn't do it without some!
Bookmarks