Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creating controls to autofill a form | Excel Discussion (Misc queries) | |||
Creating a dynamic chart | Charts and Charting in Excel | |||
creating controls at runtime | Excel Programming | |||
Dynamic Label for Controls | Excel Programming |