corsasport.co.uk
 

Corsa Sport » Message Board » Off Day » Geek Day » Excel - drop down menus


New Topic

New Poll
  Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author Excel - drop down menus
chr15barn3s
Member

Registered: 5th Oct 03
Location: Farnborough
User status: Offline
24th Aug 06 at 09:29   View User's Profile U2U Member Reply With Quote

Does anybody know how to do these? Ive done them before but I cant remember how to do them.
James
Member

Registered: 1st Jun 02
Location: Surrey
User status: Offline
24th Aug 06 at 09:31   View User's Profile U2U Member Reply With Quote

Make sure the forms toolbar is visble,

Select a combo box and then draw it on the page somewhere

Right click > Format control > control tab

Input range is the range where the data that you want to be in the list is.

Cell link is the cell where the selected value will be output
chr15barn3s
Member

Registered: 5th Oct 03
Location: Farnborough
User status: Offline
24th Aug 06 at 11:28   View User's Profile U2U Member Reply With Quote

Cheers

How do you write in the box? Before you click it down
James
Member

Registered: 1st Jun 02
Location: Surrey
User status: Offline
24th Aug 06 at 12:11   View User's Profile U2U Member Reply With Quote

Pretty sure if you want to do that you'll have to use one from the control toolbox
James
Member

Registered: 1st Jun 02
Location: Surrey
User status: Offline
24th Aug 06 at 12:14   View User's Profile U2U Member Reply With Quote

Then you need to start using VBA code to bind to it etc.....

 
New Topic

New Poll

  Related Threads Author Forum Replies Views Last Post
Help needed again ...Trotty can you help Red_Corsa Geek Day 17 1656
21st Mar 03 at 00:15
by Red_Corsa
 
koni red suspension kit jam Help Zone, Modification and ICE Advice 5 893
25th Mar 03 at 17:48
by jam
 
that scrolling notice fucks up the drop down menus Kris TD General Chat 5 132
3rd Jul 03 at 09:18
by Sam
 
Any MS Excel experts Steve Geek Day 11 1273
4th Jun 04 at 14:19
by blebo
 
is there a program that...... chris_uk Geek Day 6 1879
16th Jun 05 at 00:47
by Dan B
 

Corsa Sport » Message Board » Off Day » Geek Day » Excel - drop down menus 29 database queries in 0.0115421 seconds