Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
data validation and combo box
hi
i am using the tutorial from he http://www.contextures.com/xlDataVal10.html i have modified it for my purposes using only one column for my validation. the trouble is when i use it the Validation Box is appearing under the Combo Box i want the user to use. i does not appear that way in the sample file i down loaded if someone could look at this and perhaps suggest where i have gone wrong , i would greatly appreciate it thanx Mac |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
data validation and combo box
Did you change the code, or just the worksheet?
macataq wrote: hi i am using the tutorial from he http://www.contextures.com/xlDataVal10.html i have modified it for my purposes using only one column for my validation. the trouble is when i use it the Validation Box is appearing under the Combo Box i want the user to use. i does not appear that way in the sample file i down loaded if someone could look at this and perhaps suggest where i have gone wrong , i would greatly appreciate it thanx Mac -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
data validation and combo box
"Under" means below or behind?
Trace your modification steps against Debra's sample workbook and you should be able to see where yours differs. Gord Dibben MS Excel MVP On Sun, 28 Sep 2008 08:00:01 -0700, macataq wrote: hi i am using the tutorial from he http://www.contextures.com/xlDataVal10.html i have modified it for my purposes using only one column for my validation. the trouble is when i use it the Validation Box is appearing under the Combo Box i want the user to use. i does not appear that way in the sample file i down loaded if someone could look at this and perhaps suggest where i have gone wrong , i would greatly appreciate it thanx Mac |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
data validation and combo box
Thanks for the quick responses
the only changes i made to the sheet was to change the number of rows (from 12 to 33) the number of validation lists (from 2 to 1) and location of the list (from j2:j8 and L2:L13, to C73:c105) i am probably missing something simple. the combo box works as it is supposed to, it just not look right. and yes when i say "under" i should have said behind. it sticks out past the edge of the combo box. thanks again Mac |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
data validation and combo box
Try experimenting with these two settings in the worksheet code.
.Width = Target.Width + 15 .Height = Target.Height + 5 Play with them until you lose sight of the DV arrow Gord On Sun, 28 Sep 2008 08:58:00 -0700, macataq wrote: Thanks for the quick responses the only changes i made to the sheet was to change the number of rows (from 12 to 33) the number of validation lists (from 2 to 1) and location of the list (from j2:j8 and L2:L13, to C73:c105) i am probably missing something simple. the combo box works as it is supposed to, it just not look right. and yes when i say "under" i should have said behind. it sticks out past the edge of the combo box. thanks again Mac |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data validation - combo box | Excel Worksheet Functions | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
hyperlink in combo box/data validation | Excel Worksheet Functions | |||
List, Combo Box, Data Validation?? | Excel Discussion (Misc queries) | |||
Combo Box or Data Validation | Excel Discussion (Misc queries) |