LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
gupt
 
Posts: n/a
Default creating a combobox dynamically on an excel sheet


hi,

i'm totally new to excel and writing macros and code for it. i need to
create a file which will allow the users to click on the 11th column on
any row and select a value from the combobox that appears in that cell
on clicking.

the combobox will only appear if it is the 11th column. i plan to
create one combobox and make it invisible when the file is loaded. it
will become visible in row the user clicks (only if the col = 11). i
want to use VBA for this. but i have no clue how to! any help will be
greatly appreciated!

thanks!!

gupt


--
gupt
------------------------------------------------------------------------
gupt's Profile: http://www.excelforum.com/member.php...o&userid=24067
View this thread: http://www.excelforum.com/showthread...hreadid=376700

 
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
Password for excel sheet vishu Excel Discussion (Misc queries) 1 May 12th 05 03:37 PM
Starting MS Excel with a worksheet other than SHEET 1 IGNACIO Excel Worksheet Functions 2 February 18th 05 06:29 PM
Creating GIFs in Excel 2003 for use in Dreamweaver Lou Crandall Charts and Charting in Excel 2 January 2nd 05 07:58 PM
How do I duplicate a sheet 20 times in an excel spreadsheet danzil Excel Worksheet Functions 4 December 17th 04 09:23 PM
Hyperlink to specific sheet in Excel Web File jd17 Links and Linking in Excel 0 December 8th 04 09:03 PM


All times are GMT +1. The time now is 11:55 PM.

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

About Us

"It's about Microsoft Excel"