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: 3
Default Programming popup forms

I am trying to create a macro that opens a popup form.

The popup form has a series of check boxes (10-15).

When the popup form closes (or maybe when the user clicks an "OK"
button), I want to the macro to select a cell on the current row and a
defined column and for every check box that's selected, insert some
text in the cells starting with the selected cell and, in the same
column, on the rows below, advancing one row for each additional
selected check box. Does that make sense?

E.g. Say the cursor is in A25 and four check boxes were ticked (item
1, item 7, item 8 and item 13). The defined column is J.

On closing the popup form Cell J25 would contain Item1, J26: Item 7,
J27: item 8 and J28: item 13.

Any ideas?

Regards,
Richard.
--
Regards.
Richard.
 
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
RefEdits and normal forms / forms in a DLL David Welch Excel Programming 0 December 1st 04 03:49 PM
Forms that open from forms Azza Excel Programming 1 October 12th 04 10:54 PM
Calling Forms from Forms - Exit problems Stuart[_5_] Excel Programming 3 May 25th 04 06:50 AM
Are you sure popup box Todd Huttenstine[_2_] Excel Programming 2 November 9th 03 09:38 PM
Forms Toolbar Programming KB[_2_] Excel Programming 1 September 27th 03 06:21 PM


All times are GMT +1. The time now is 05:28 PM.

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"