Thread: adding an integer to a string in code
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pspyve[_8_] pspyve[_8_] is offline
external usenet poster
  
Posts: 1
Default adding an integer to a string in code

Hi Guys,

Problem: I have 100 buttons on a userform named
Construct.Slat1
Construct.Slat2
Construct.Slat3
etc etc
I need to make some of them invisible i.e
from visSlats to 100

Here is my code.

visSlats = Range("Vis").Value
visSlats = visSlats + 1
For v = visSlats To 100
Construct.Slat(v).Visible = False
Next v

(This dosent work)
Where Construct is the userform name

What do I need to do to make this work??

Phi

--
pspyv
-----------------------------------------------------------------------
pspyve's Profile: http://www.excelforum.com/member.php...fo&userid=3065
View this thread: http://www.excelforum.com/showthread.php?threadid=57129

Reply With QuoteReply With Quote