#1
|
|||
|
|||
Yes/No form box that is clickable
Hi All
First post here and am sure this is really easy but I cannot find the correct thing to search in google to give me the answer. I am trying to create an electronic form to be sent and then returned, in the original paper form, I have a part where I have Yes/No? I would like this to be a clickable box of some sort, when clicked once it turns into a green circle around the Yes, when clicked again a red circle around the no and clicked again returns to standard. Hopefully someone will have a link to this from another question so nobody has to work on this. Thanks in advance Darren |
#2
|
||||
|
||||
Perhaps something like the attached. Note that you need to tab out of the formfield to trigger the update.
For some alternative approaches, see: https://www.msofficeforums.com/word-...html#post47254
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Hi Paul
Thanks for the quick response, although this gives me the option to get a yes or no answer, the form will still be used as a paper copy, so will need to be printed with just the Yes/No? showing on a blank printed form but if I want it sent as an electronic version I would like to see something like the pictures attached. |
#4
|
||||
|
||||
The simplest solution would be to change 'Choose' to 'Yes/No'. See attached. Note also the prompt I've added to the status bar.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
Hi Paul
Thanks for the reply again. I am struggling to get this to work and look right on the page, I have now found this though that looks quite good, it works as suggested in the original post but, I tried to change the "N" for "NO" and "?" to "YES/NO?" and "Y" to "YES" this appears to break the use! Any ideas how to fix this? Thanks Darren link to thread I found Enable a user to double-click text in a document to change its value Original code my code below Sub SymbolCarousel() ' ' SymbolCarousel Macro ' ' Select Case Selection.Fields(1).Code.Characters(29) Case "YES" Selection.Fields(1).Code.Characters(29) = "NO" Case "NO" Selection.Fields(1).Code.Characters(29) = "YES/NO?" Case "YES/NO?" Selection.Fields(1).Code.Characters(29) = "YES" Case Else End Select End Sub |
#6
|
||||
|
||||
Obviously, I'd have thought, if you're going to change the selections, the tests for what is selected will have to change as well. Testing for 'Yes' is not the same as testing for 'Y'.
There is no macro code in the document I posted. As you'll see it's a docx file; docx files cannot contain macros. The entire process is managed through field coding.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to Make a Dynamic URL Clickable? | DKY | Mail Merge | 1 | 03-29-2020 04:43 PM |
Clickable image | DarrenOakey | Drawing and Graphics | 1 | 08-13-2015 05:37 PM |
Add button or clickable text to form that opens up user's email client with To field populated | richiebabes | Word VBA | 3 | 09-04-2014 09:21 PM |
clickable checkbox on slide | drodriguez | PowerPoint | 3 | 10-19-2013 04:33 AM |
hyperlink not clickable | turtleshell | PowerPoint | 1 | 01-14-2012 07:02 PM |