#1   Report Post  
Monty
 
Posts: n/a
Default Combo box

if i set up a combo box in worksheet 2 can i have the name a select in this
combo box put into a cell in worksheet on.

thanks for your help
  #2   Report Post  
Mangesh Yadav
 
Posts: n/a
Default

Yes you can.

Worksheets("Sheet1").Range("A1") = Worksheets("Sheet2").ComboBox1.Value

should do the trick.

Mangesh




"Monty" wrote in message
...
if i set up a combo box in worksheet 2 can i have the name a select in

this
combo box put into a cell in worksheet on.

thanks for your help



  #3   Report Post  
Monty
 
Posts: n/a
Default

Thanks

this worked . however i have decided to use cell validition and transpose.

"Mangesh Yadav" wrote:

Yes you can.

Worksheets("Sheet1").Range("A1") = Worksheets("Sheet2").ComboBox1.Value

should do the trick.

Mangesh




"Monty" wrote in message
...
if i set up a combo box in worksheet 2 can i have the name a select in

this
combo box put into a cell in worksheet on.

thanks for your help




  #4   Report Post  
Monty
 
Posts: n/a
Default

Thanks

this worked . however i have decided to use cell validition and transpose.

"Mangesh Yadav" wrote:

Yes you can.

Worksheets("Sheet1").Range("A1") = Worksheets("Sheet2").ComboBox1.Value

should do the trick.

Mangesh




"Monty" wrote in message
...
if i set up a combo box in worksheet 2 can i have the name a select in

this
combo box put into a cell in worksheet on.

thanks for your help




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
Dynamic Combo Box benjarfer Excel Worksheet Functions 2 April 8th 05 02:17 PM
connecting combo boxes to yield data in another cell. TxN8tv Excel Discussion (Misc queries) 0 March 14th 05 05:07 PM
extract data from combo box n use it in SQL benj Excel Discussion (Misc queries) 2 February 16th 05 10:54 AM
"Combo Box - getting control combo box to stick in place in worksh ajr Excel Discussion (Misc queries) 1 February 16th 05 03:05 AM
dynamic combo boxes tjb Excel Worksheet Functions 2 January 25th 05 08:33 PM


All times are GMT +1. The time now is 11:29 AM.

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"