LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35
Default Data Validation combo box click - 2007

I am trying to create data validation with larger text and have followed the
instructions in here http://www.contextures.com/xlDataVal14.html precisely
but it's not working. I'm working in Excel 2007. Is there something different
I need to do??

It appears to run a macro when I click on the cell but the validation list
doesn't appear. I am using a named range for my validation list but I can't
imagine that would help. I don't know where to start to debug it - I'm not
used to working with these sort of macros, ie I can't seem to 'step' into it
with F8. How can I debug it to see where it's falling over??

Is there anyone who can help replicate the instructions on this website for
Excel 2007?

Thank you!
 
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
Data Validation - Combo Box open with single click GoBucks[_2_] Excel Programming 0 October 9th 09 03:29 PM
data validation and combo box macataq Excel Discussion (Misc queries) 4 September 28th 08 06:03 PM
Data validation - combo box susan Excel Worksheet Functions 4 May 23rd 08 11:44 PM
Data validation with validation lists and combo boxs Keith Excel Discussion (Misc queries) 1 October 12th 06 11:08 AM
Combo Box or Data Validation FA Excel Discussion (Misc queries) 17 September 27th 05 01:58 PM


All times are GMT +1. The time now is 02:56 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"