Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-18-2020, 01:00 AM
dazza67 dazza67 is offline Yes/No form box that is clickable Windows 10 Yes/No form box that is clickable Office 2016
Novice
Yes/No form box that is clickable
 
Join Date: Apr 2020
Posts: 3
dazza67 is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 04-18-2020, 01:47 AM
macropod's Avatar
macropod macropod is offline Yes/No form box that is clickable Windows 7 64bit Yes/No form box that is clickable Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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
Attached Files
File Type: docx FormfieldCircle.docx (29.5 KB, 7 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 04-18-2020, 02:25 AM
dazza67 dazza67 is offline Yes/No form box that is clickable Windows 10 Yes/No form box that is clickable Office 2016
Novice
Yes/No form box that is clickable
 
Join Date: Apr 2020
Posts: 3
dazza67 is on a distinguished road
Default

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.
Attached Images
File Type: jpg yesno.JPG (11.2 KB, 20 views)
Reply With Quote
  #4  
Old 04-18-2020, 03:51 AM
macropod's Avatar
macropod macropod is offline Yes/No form box that is clickable Windows 7 64bit Yes/No form box that is clickable Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by dazza67 View Post
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?
The simplest solution would be to change 'Choose' to 'Yes/No'. See attached. Note also the prompt I've added to the status bar.
Attached Files
File Type: docx FormfieldCircle.docx (29.6 KB, 12 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 04-18-2020, 06:14 AM
dazza67 dazza67 is offline Yes/No form box that is clickable Windows 10 Yes/No form box that is clickable Office 2016
Novice
Yes/No form box that is clickable
 
Join Date: Apr 2020
Posts: 3
dazza67 is on a distinguished road
Default

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
Reply With Quote
  #6  
Old 04-18-2020, 02:32 PM
macropod's Avatar
macropod macropod is offline Yes/No form box that is clickable Windows 7 64bit Yes/No form box that is clickable Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Yes/No form box that is clickable How to Make a Dynamic URL Clickable? DKY Mail Merge 1 03-29-2020 04:43 PM
Yes/No form box that is clickable Clickable image DarrenOakey Drawing and Graphics 1 08-13-2015 05:37 PM
Yes/No form box that is clickable 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
Yes/No form box that is clickable hyperlink not clickable turtleshell PowerPoint 1 01-14-2012 07:02 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:58 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft