View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bijl167[_12_] Bijl167[_12_] is offline
external usenet poster
 
Posts: 1
Default Excel VBA -making Objectnames variable

Hi,

I have X objects on a Form on which the same actions need to be done a
initialisation. Does anyone know how I can do this without typing th
code for all objects.

what I have tried


from i=1 to end

tickbox= "object" & i

With tickbox
.value=true
.enabled= true
.visible=true

next i


The problem that I have is that I don't get VBA to recognise th
varuiable tickbox as an objectname, tho there is an object name
"objectname1"

Can anyone help
Thnx

--
Message posted from http://www.ExcelForum.com