Drop-down on Datagrid

[chrsab]

Hello

I have a datagrid which has a couple of yes/no fields, i have made it so a dropdown list button is visible when click on the cell but nothing is displayed in the list. How can i do this? The following code is what i use to display the dropdown button.

With DataGrid1

.Columns(5).Button = True
.Columns(8).Button = True
.Columns(9).Button = True
.Columns(10).Button = True
.Columns(5).NumberFormat = "Yes/No"
.Columns(8).NumberFormat = "Yes/No"
.Columns(9).NumberFormat = "Yes/No"
.Columns(10).NumberFormat = "Yes/No"

End With

Thanx for any help

 

[SQLScholar]

Did you find anything about this?

From what i can see the only way to do it is to have a floating combo box over the top of the cell.



----------------------------------------
There are 2 types of computer, the prototype and the obsolete!!
----------------------------------------
No D, just plank - and its not my fault

 

[SQLScholar]

or a list box.... as here

http://www.tek-tips.com/viewthread.cfm?qid=271034

----------------------------------------
There are 2 types of computer, the prototype and the obsolete!!
----------------------------------------
No D, just plank - and its not my fault

 

[oops4me]

hello,
see following link

http://www.codeguru.com/forum/printthread.php?t=25922

 

[johnwm]

Try faq222-3262

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller