Posted to microsoft.public.excel.programming

external usenet poster

Posts: 169

Inserting row when option is chosen

I have a worksheet "rates"

a2 is a data validation drop-down box- with list from e1:e20
and a3 has an entry,
if an option is chosen in a2
then a line is inserted with a3 having the same data validation drop-down
box
etc.etc.

I have this as a private sub workbook_open ()
as this has to initialise when the workbook is open.

Help is much appreciated

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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
macro so no option button chosen	Ken Ivins[_2_]	Excel Programming	0	September 17th 04 08:51 PM
macro so no option button chosen	Ken Ivins[_2_]	Excel Programming	0	September 17th 04 08:18 PM
macro so no option button chosen	Ken Ivins[_2_]	Excel Programming	2	September 17th 04 05:31 PM
validate an option is chosen	DaveB[_3_]	Excel Programming	3	February 23rd 04 09:11 PM
User Option to save to chosen destination	patterson_m[_4_]	Excel Programming	1	October 13th 03 05:41 PM

All times are GMT +1. The time now is 10:35 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us