Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 1st 04, 06:47 AM
Geoff D'Arcy
 
Posts: n/a
Default Excel Programming help

I need some help with a workbookI am making. I am fairly capable of most
excel uses, however I am working from someone else's sheet which has a lot
of protected cells and I would like to simply make my own that looks the
same. But I like how he did his "drop down menu" to change the date, so I
need to know how to go about doing that? Would someone have the time to
look over this file and give me an idea how I can recreate this? Thanks.

Geoff



  #2   Report Post  
Old November 1st 04, 11:36 AM
Alex Delamain
 
Posts: n/a
Default


Without looking at the spreadsheet any drop down list is generally
created using

data, validation, then set the "allow" property to "list" then set the
source range to include the data you want to pick from.


--
Alex Delamain
------------------------------------------------------------------------
Alex Delamain's Profile: http://www.excelforum.com/member.php...o&userid=11273
View this thread: http://www.excelforum.com/showthread...hreadid=274096

  #3   Report Post  
Old November 1st 04, 06:31 PM
Frank Kabel
 
Posts: n/a
Default

Hi
see:
http://www.contextures.com/xlDataVal01.html

--
Regards
Frank Kabel
Frankfurt, Germany


Geoff D'Arcy wrote:
I need some help with a workbookI am making. I am fairly capable of
most excel uses, however I am working from someone else's sheet which
has a lot of protected cells and I would like to simply make my own
that looks the same. But I like how he did his "drop down menu" to
change the date, so I need to know how to go about doing that? Would
someone have the time to look over this file and give me an idea how
I can recreate this? Thanks.

Geoff




Reply
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
How do I isolate my Excel server (automation) from other Excel instances? Joseph Geretz Excel Discussion (Misc queries) 5 July 19th 13 03:18 PM
sharing/using/saving Excel 2002 files in Excel 2003 maze2009 Excel Discussion (Misc queries) 0 January 20th 05 07:27 PM
Excel 2002 and 2000 co-install. Control Which Starts ? cnuk Excel Discussion (Misc queries) 2 January 17th 05 08:07 PM
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 1 January 5th 05 08:36 AM
VB Automation is Whacking out my Excel Environment Joseph Geretz Excel Discussion (Misc queries) 2 December 29th 04 03:49 PM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017