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

Linux (Mint is primary) / XP, Win7 Home / Win7 Pro, Ultimate / Win8.1 / Win10 archived VM
 
 

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




Similar help and support threads
Thread Forum
Sub Windows minimized to desktop have no caption or restore button
Before delving into trial and error of uninstalling recent Windows Updates I wanted to ask if anyone has encountered a recent appearance change in windows minimized to the desktop (not taskbar). In the past few weeks any sub window of an application that normally minimizes to the desktop with a...
General Discussion
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
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


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 03:55.
Twitter Facebook Google+