Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-02-2015, 05:47 AM
MOHAMMEDSALMAN MOHAMMEDSALMAN is offline Assign dynamic value to checkboxes Windows 7 64bit Assign dynamic value to checkboxes Office 2007
Novice
Assign dynamic value to checkboxes
 
Join Date: Sep 2015
Location: Mumbai
Posts: 9
MOHAMMEDSALMAN is on a distinguished road
Unhappy Assign dynamic value to checkboxes

HI,

I have created a runtime checkboxes in vba. This checkboxes are reference to excel rows :-

Equipment Finishing (painting, scratches, damage, etc)
Equipment Alignment (doors, removable panels/covers, locks, section-to section, etc)
Equipment / Device Labels/Nameplates and Component Layout


Torque Marking
Component / Device Inspection (damage to parts, missing screws, etc)


I want checkbox to hold values
0.50
-
0.50
0.50
0.25

and at the end i want to add this values. This values will not be fixed. It will change depend on selection of header("Gis Swgr" "SF6 swgr" and so on).

I had put "Gis Swgr" "SF6 swgr" and so on in combo box. If combo box change then checkbox value should get change.

http://www.vbforums.com/showthread.p...83#post4925583

Please find the above link for my query. Please help me out.
Reply With Quote
  #2  
Old 09-02-2015, 12:08 PM
NoSparks NoSparks is offline Assign dynamic value to checkboxes Windows 7 64bit Assign dynamic value to checkboxes Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

Would be to your benefit to post .xlsm rather than .jpg
Reply With Quote
  #3  
Old 09-06-2015, 09:57 AM
NoSparks NoSparks is offline Assign dynamic value to checkboxes Windows 7 64bit Assign dynamic value to checkboxes Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

I've read the thread at the link you posted.
Seems more complicated than it should be.

Had the original question been posted here, my first response would have been...
Tell me what you're trying to do, not how you can't do it.

Preconceived notions are not always the way to go.

Anyway, good luck with your project.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Checkboxes in Excel asmanokhchi Excel 0 04-28-2015 11:13 PM
Checkboxes in cells kristofferwok Excel 0 03-24-2015 04:19 AM
Assign dynamic value to checkboxes checkboxes smohap Word 1 06-19-2011 09:24 PM
Ticking Checkboxes screid Word 1 06-08-2010 02:04 AM
Manipulating checkboxes in XML Ivo Word 0 12-06-2005 09:04 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:06 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