LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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



.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating controls to autofill a form wepstech Excel Discussion (Misc queries) 2 February 23rd 07 01:00 PM
Creating a dynamic chart Fysh Charts and Charting in Excel 9 December 15th 04 02:52 AM
creating controls at runtime defj Excel Programming 2 December 2nd 03 07:14 AM
Dynamic Label for Controls Rob Bovey Excel Programming 0 September 8th 03 06:47 PM


All times are GMT +1. The time now is 06:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"