View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
monika monika is offline
external usenet poster
 
Posts: 27
Default creating dynamic controls

Infact I ahave the code for getting the option buttons
dynamically. this is most commonly used. I am unable to
add it...

like see the code below adding hte optionbuttons..
For i = 1 To ActiveWorkbook.Worksheets.Count
Set CurrentSheet = ActiveWorkbook.Worksheets(i)
iBooks = iBooks + 1
PrintDlg.OptionButtons.Add 78, TopPos, 150, 16.5
PrintDlg.OptionButtons(iBooks).Text = _
ActiveWorkbook.Worksheets(iBooks).Name
TopPos = TopPos + 13
Next i

like wise ..i want to know hwo to add the refedit...which
i am not able to do so...

any help..?

any suggestions?

-----Original Message-----
Hi

See if this gets you started:
http://www.j-walk.com/ss/excel/tips/tip76.htm

--
HTH. Best wishes Harald
Followup to newsgroup only please

"monika" skrev i

melding
...
I had another question related to refedit's. I want to
generate refedits on form based on a certain array
values..dynamically.
like if my array has 5 i want 5 refedits to be added in

my
form..how can i do this..

Thanks in advance



.