Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Textbox question 2
Now that harald has helped me with the code for the autocomplete coud him or
someone help me with the backspace key to work in the textbox Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Textbox question 2
The functionality is built into a Combobox - it also supports the
backspace - so you want someone to help you reinvent the wheel? -- Regards, Tom Ogilvy "Rich Cooper" wrote in message ... Now that harald has helped me with the code for the autocomplete coud him or someone help me with the backspace key to work in the textbox Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Textbox question 2
I guess my answer to your question unfortanually is yes
If you could help me that would be great otherwise i will keep on reading and looking till i get it to work using the textbox "Tom Ogilvy" wrote in message ... The functionality is built into a Combobox - it also supports the backspace - so you want someone to help you reinvent the wheel? -- Regards, Tom Ogilvy "Rich Cooper" wrote in message ... Now that harald has helped me with the code for the autocomplete coud him or someone help me with the backspace key to work in the textbox Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Textbox question 2
I can only guess that you do not realize that if you use a combobox, set the
range as the rowsource and set the property ShowDropDownWhen to fmShowDropButtonWhenNever Match Entry to FmMatchEntryComplete (the default) that the dropdown will never display and you get the functionality you have right now plus the backspace and so forth are handled all with no additional code. So, saying you won't use the Combobox sounds like you just don't know this. -- Regards, Tom Ogilvy "Rich Cooper" wrote in message ... I guess my answer to your question unfortanually is yes If you could help me that would be great otherwise i will keep on reading and looking till i get it to work using the textbox "Tom Ogilvy" wrote in message ... The functionality is built into a Combobox - it also supports the backspace - so you want someone to help you reinvent the wheel? -- Regards, Tom Ogilvy "Rich Cooper" wrote in message ... Now that harald has helped me with the code for the autocomplete coud him or someone help me with the backspace key to work in the textbox Thanks |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Textbox question 2
Tom, i understand the combobox and all, i am creating a report for a client
and they are requested if it could be done by a textbox so i am trying that first....else i will do the combobox if all else fails "Tom Ogilvy" wrote in message ... I can only guess that you do not realize that if you use a combobox, set the range as the rowsource and set the property ShowDropDownWhen to fmShowDropButtonWhenNever Match Entry to FmMatchEntryComplete (the default) that the dropdown will never display and you get the functionality you have right now plus the backspace and so forth are handled all with no additional code. So, saying you won't use the Combobox sounds like you just don't know this. -- Regards, Tom Ogilvy "Rich Cooper" wrote in message ... I guess my answer to your question unfortanually is yes If you could help me that would be great otherwise i will keep on reading and looking till i get it to work using the textbox "Tom Ogilvy" wrote in message ... The functionality is built into a Combobox - it also supports the backspace - so you want someone to help you reinvent the wheel? -- Regards, Tom Ogilvy "Rich Cooper" wrote in message ... Now that harald has helped me with the code for the autocomplete coud him or someone help me with the backspace key to work in the textbox Thanks |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Textbox question 2
Tom, i have inserted the combobox i am sending a demo off using the combobox
thanks for your help "Rich Cooper" wrote in message ... Tom, i understand the combobox and all, i am creating a report for a client and they are requested if it could be done by a textbox so i am trying that first....else i will do the combobox if all else fails "Tom Ogilvy" wrote in message ... I can only guess that you do not realize that if you use a combobox, set the range as the rowsource and set the property ShowDropDownWhen to fmShowDropButtonWhenNever Match Entry to FmMatchEntryComplete (the default) that the dropdown will never display and you get the functionality you have right now plus the backspace and so forth are handled all with no additional code. So, saying you won't use the Combobox sounds like you just don't know this. -- Regards, Tom Ogilvy "Rich Cooper" wrote in message ... I guess my answer to your question unfortanually is yes If you could help me that would be great otherwise i will keep on reading and looking till i get it to work using the textbox "Tom Ogilvy" wrote in message ... The functionality is built into a Combobox - it also supports the backspace - so you want someone to help you reinvent the wheel? -- Regards, Tom Ogilvy "Rich Cooper" wrote in message ... Now that harald has helped me with the code for the autocomplete coud him or someone help me with the backspace key to work in the textbox Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TextBox Question | Excel Discussion (Misc queries) | |||
Textbox question | Excel Discussion (Misc queries) | |||
Textbox question | Excel Discussion (Misc queries) | |||
Textbox question? | Excel Discussion (Misc queries) | |||
Simple textbox question | Excel Programming |