View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
routeram[_8_] routeram[_8_] is offline
external usenet poster
 
Posts: 1
Default Linking labels to cells and turning off events in userform


Hi all of you,

2 Questions:

I want to show the contents of a particular cell in a label on th
userform. How do I do it? Is it possible to link the caption to th
cell so that if the cell changes, the label will change too?

Also I do some intialisation of scrollbars during th
userform_initialise. But I don't want the scrollbar_change event to ru
during initialisation. Is there a way to switch off the events in th
userform and enable them again at the end of the initialisatio
routine? (Purely for speeding up the code). Any work arounds?

Thanks a lot. You guys are great!


Regards,
Ra

--
routera
-----------------------------------------------------------------------
routeram's Profile: http://www.excelforum.com/member.php...fo&userid=1045
View this thread: http://www.excelforum.com/showthread.php?threadid=27793