LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 34
Default Displaying Cell Value in UserForm Label

I have created an Excel Add-In that formerly displayed the add-in's version
and date in a message box based on values in one of the add-ins worksheets
using the following (where A1 contained the version number and A2 contained
the date last updated):

Sub DisplayVersion

Msgbox "Version "&Worksheets("Sheet1").Range("A1")& _
" updated on "&Worksheets("Sheet1").Range("A2")

End Sub

I am trying to move this function to a UserForm but can not figure out how
to get data from a worksheet into a string of text in a label within the
UserForm. Can someone point me to an example?

Thank you,

Frank Hayes


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Userform with textbox displaying Cell B1 Value JMay Excel Discussion (Misc queries) 2 October 4th 09 12:56 AM
Userform Label Steve[_9_] Excel Discussion (Misc queries) 7 October 29th 07 09:51 PM
Displaying cell values in a Userform michaelberrier Excel Discussion (Misc queries) 3 June 8th 06 05:24 PM
Userform Label question David Goodall Excel Programming 2 October 29th 04 03:33 PM
Userform blinking label Ed Excel Programming 2 July 17th 04 12:24 AM


All times are GMT +1. The time now is 01:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"