Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-17-2012, 11:31 PM
macropod's Avatar
macropod macropod is offline How to link checkbox to change nearby cell value? Windows 7 64bit How to link checkbox to change nearby cell value? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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

See attached demo of a dropdown pretending to be a checkbox.
Attached Files
File Type: doc DropdownDemo.doc (39.5 KB, 97 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 08-18-2012, 04:51 PM
derby46a derby46a is offline How to link checkbox to change nearby cell value? Windows 7 64bit How to link checkbox to change nearby cell value? Office 2010 32bit
Novice
How to link checkbox to change nearby cell value?
 
Join Date: Aug 2012
Posts: 8
derby46a is on a distinguished road
Default

Thank you for the example. I was trying to see the formula or macro behind how this works, though, and it's not letting me. Can you let me in on how the dropdown and the adjacent cell are linked, specifically, what formula or macro is used? I appreciate your answers.

Sincerely,
derby46a
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Detect a cell has un-approved change or not? LongTTH Excel Programming 1 05-20-2012 02:22 AM
How to link checkbox to change nearby cell value? how to change number in cell ubns Excel 5 05-14-2012 04:21 PM
Link and change source for multiple tabs from excel to powerpoint excel3 PowerPoint 1 01-19-2012 02:01 AM
CHange colour of footer if a cell changes to red OTPM Excel 0 05-26-2011 07:15 AM
highlight cell after checkbox flatk Word 0 01-25-2007 12:32 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:24 AM.


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