Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-18-2017, 06:59 AM
Larry_1 Larry_1 is offline Assigning a string variable to a userform label caption Windows 10 Assigning a string variable to a userform label caption Office 2010 64bit
Novice
Assigning a string variable to a userform label caption
 
Join Date: Dec 2017
Posts: 9
Larry_1 is on a distinguished road
Default Thank you!

I know that, in the fields where I have significant experience, one difficulty in talking to beginners is that what's blindingly obvious to a person with *any* experience at all is completely opaque to a beginner.

I tried the code that you suggested and could not make it work. After practicing my black language skills and bruising my forehead, I gave up and went to bed. But I had a thought when I woke this morning: you'd use "show" . . . I'd used that command in a module rather than the userform's VBE. I created a module, inserted the code that you suggested into the module, and it worked first try.

Thank you!

And I annotated this in my "Excel VBA Programming for Dummies" to increase the chance that I'll remember it next time. Now I need to try understanding where VBA expects me to put things.



VERY respectfully,
Larry
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Assigning a string variable to a userform label caption how to have two formats in the Caption style: Label – number - text? Jamal NUMAN Word 39 03-14-2017 06:32 PM
Assigning Form.ActiveControl.Name to variable aramaglia Excel Programming 0 02-10-2017 09:57 AM
Userform label bordercolor not controllable if click label skarden Word VBA 1 09-29-2013 07:27 PM
Assigning a string variable to a userform label caption Custom caption list label lost in a new Word session New Daddy Word 1 09-22-2013 09:21 AM
Custom caption label annoyance zac Word 1 08-29-2010 09:56 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:01 PM.


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