View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jinx_uk_98 jinx_uk_98 is offline
external usenet poster
 
Posts: 1
Default rename label captions


Hi all,

Bit of a newbie here so please be gentle.

I have 200 cells that require data to be entered into them but I want
to do this via a userform.

The 200 cells can be divided in 4 major headings with 25 subheadings
(cells) in each section. (these can be increased or decreased over
time)

Rather than have 200 textboxes on my userform I wanted to list the 4
major heading in a listbox then when a major heading is clicked the
captions and visablity of the 25 labels and textboxes would be set.


Is this possible?


Regards
Kevin


--
jinx_uk_98
------------------------------------------------------------------------
jinx_uk_98's Profile: http://www.excelforum.com/member.php...o&userid=28878
View this thread: http://www.excelforum.com/showthread...hreadid=486258