Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel: How can I insert the value of cell into ActiveX button caption?

16 Jul 2012   #11
GEWB

Several flavors of Linux (Mint primary) / 32bit XP, Win7 HomeP / 64bit Win7 Pro, Ultimate / 64Win8.1
 
 

Quote   Quote: Originally Posted by kegobeer View Post
No, he wants to dynamically change the label.
Ah, my bad. I think you are correct - VB is the way to do it.

Regards,
GEWB


My System SpecsSystem Spec
.
17 Jul 2012   #12
Peatawn

Windows 7 Home (x64)
 
 

FYI, I've found the code I needed. Simple as a matter of fact.

Under ThisWorkbook > Workbook, the code is:
Private Sub Workbook_Open()
ThisWorkbook.Worksheets("RAID_PRV").ClearWeek.Caption = "Clear week " & ThisWorkbook.Sheets("RAID_PRV").Range("OldestWeek")
End Sub


I'd like to thank everyone who wanted to help and spent the time doing so.
Peatawn
My System SpecsSystem Spec
Reply

 Excel: How can I insert the value of cell into ActiveX button caption?




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
Can I compare 2 Excel spreadsheets cell by cell?
I have an Excel 2010 workbook comprising a simple organization membership list, consisting of names, addresses, etc., for nearly 2,000 members, grouped into 5 chapters' sheets, in a single Excel 2010 file. Every time I sit down to enter updates for any member, or add new members, etc., I always ...
Microsoft Office
Move caption button in vista style builder
http://i.imgur.com/tzxPccc.jpg i wanna put my close button in the corner, somehow like this: http://i.imgur.com/IosEdQ4.jpg i've tried to change the value both of sizing and content margins, but this close button doesn't move at all. can someone help me? note:
Customization
Excel cell
Office 2010/Excel I accidentally entered an email address into a cell and now I can't get rid of that format in that cell. No matter what I do, whenever I try to enter text into that cell it is always illuminated in blue and is underlined, just like email addresses are. How can I make this cell...
Microsoft Office
Excel 2010 Multiply cell
I am kinda stuck with this issue, basically what I want to do is multiply any number which is put in row H by 10 and put the value in the next cell in row I, how can I do this? Thanks
Microsoft Office
How to fix caption button size smaller than 18 ?
Hi. I found a bug in explorer, which resets caption button size to 18 (if you use smaller size) when you use fullscreen applications (games). It may seem like a trivial issue but I think those icons are still too big and ugly when using value 18. Is there a way to fix it, somehow set it to 14...
Themes and Styles
Windows Font size for Tab Control /button caption or form too Small
I have no idea how it happened but the font type and size of all the captions of controls like tab, button, form text etc had changes and has gone too small. My window color and appereance is all set to size 9 Segoe UI. The Setting seems to have affected some windows and seems to not affect...
Customization


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 07:48.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App