MikeyW1969
Board Regular
- Joined
- Apr 28, 2014
- Messages
- 80
Hi guys,
I have a couple of questions, I figure the second and third ones are simple enough they don't need a separate topic.
Anyway, I have a document that I use for facility walkthroughs with Pass/Fail dropdowns for room components, a dropdown for facility names, etc. I have been building this with help from this site, and I just need to polish it a little before signing off on it.
Anyway, I would like to know if I can change the code of a dropdown to make clicking inside the dropdown enough to activate it, or if I can set the drop down arrow not to be the tiny, unnoticeable thing on the right hand side. Most of this is in VBA, except for some text properties for cells, and it's all working on my Android tablet, I would just like to make the pulldown more noticeable for the rest of my team.
Followup question #1: I have been tweaking the code, saving the file, and then tweaking again. At some point, I accidentally did a test once and then saved it. This hasn't ruined anything, it just gives me dropdowns which shouldn't appear until the user has entered the right number of rooms and activated the macros. Is there an easy way to remove this formatting and make the document go back? I'm aware that 'undo' doesn't work after a macro. Also, this would save time in my design process if I didn't have to test, close the file without saving, and then reopen it to tweak the code and re-test on a virgin document.
Followup question #2: What is the recommended format to save when I finish the walkthrough and mail the final file to my team(Or one of them sends one out)? I want the comments I inserted to show up with hover, but they wouldn't need the dropdowns to show up on the document when it's the one we'll be archiving, so I was wondering what the best format would be.
As always, thanks for everyone's assistance!
I have a couple of questions, I figure the second and third ones are simple enough they don't need a separate topic.
Anyway, I have a document that I use for facility walkthroughs with Pass/Fail dropdowns for room components, a dropdown for facility names, etc. I have been building this with help from this site, and I just need to polish it a little before signing off on it.
Anyway, I would like to know if I can change the code of a dropdown to make clicking inside the dropdown enough to activate it, or if I can set the drop down arrow not to be the tiny, unnoticeable thing on the right hand side. Most of this is in VBA, except for some text properties for cells, and it's all working on my Android tablet, I would just like to make the pulldown more noticeable for the rest of my team.
Followup question #1: I have been tweaking the code, saving the file, and then tweaking again. At some point, I accidentally did a test once and then saved it. This hasn't ruined anything, it just gives me dropdowns which shouldn't appear until the user has entered the right number of rooms and activated the macros. Is there an easy way to remove this formatting and make the document go back? I'm aware that 'undo' doesn't work after a macro. Also, this would save time in my design process if I didn't have to test, close the file without saving, and then reopen it to tweak the code and re-test on a virgin document.
Followup question #2: What is the recommended format to save when I finish the walkthrough and mail the final file to my team(Or one of them sends one out)? I want the comments I inserted to show up with hover, but they wouldn't need the dropdowns to show up on the document when it's the one we'll be archiving, so I was wondering what the best format would be.
As always, thanks for everyone's assistance!
