creating dynamic controls

[monika]

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

 

[Harald Staff]

Hi

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

 

[monika]

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?