Prev Previous Post   Next Post Next
  #1   Report Post  
Jeff
 
Posts: n/a
Default Form Combo Box

Hi

In Cell A1 I have a link to a Index function that uses Indirect(A1) to look
up a named range.

I also am making a form, and I just want the form to choose between some
names that are located in cells "Z1:Z10" of the worksheet and put the
selected name in Cell A1.

How do you link the combo box to cells Z1:Z10, and put your choice in cell A1?

Thanks a lot for your help


 
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
Double combo charts - are they possible? Steve Charts and Charting in Excel 2 December 17th 04 02:25 PM
Combo Box Showing numbers not dates Mo Excel Discussion (Misc queries) 1 December 14th 04 05:39 PM
combo box formatting scrabtree23 Excel Discussion (Misc queries) 1 December 4th 04 05:07 PM
Forcing Combo box entry in VBA Anthony Slater Excel Discussion (Misc queries) 1 December 1st 04 03:09 PM
A "previous" button on a user form Anthony Slater Excel Discussion (Misc queries) 3 November 29th 04 05:57 PM


All times are GMT +1. The time now is 10:24 PM.

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

About Us

"It's about Microsoft Excel"