Thread: User Form Info
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default User Form Info

Debra Dalgleish has a list of books at her site:
http://www.contextures.com/xlbooks.html

John Walkenbach's is a nice one to start with.

Depending on how advanced you are...

Professional Excel Development
By Stephen Bullen, Rob Bovey, John Green

See if you can find them in your local bookstore/internet site and you can
choose what one you like best.

Peter wrote:

Thankyou both, Works a treat.

Any reccomended reading for excel programming? I like the VBA system for
some reason.

Thanks again
Peter

"mudraker" wrote:


Peter

yes a macro can read the value af cell h96 and have that displayed on
a form in a way that it can not be modified by the user

here is one way

Private Sub UserForm_Initialize()
Me.Label1.Caption = Range("h96")
End Sub


--
mudraker
------------------------------------------------------------------------
mudraker's Profile: http://www.excelforum.com/member.php...fo&userid=2473
View this thread: http://www.excelforum.com/showthread...hreadid=532475



--

Dave Peterson