1) How to detect that <enter is press on a editable combobox activeX
control?
From property of combobox, Style is set to DropDownCombo!

2) How to stop ActiveX control Date and Time Picker resize automatically?
As I'm using Worksheet_SelectionChange to detect that if certain range of
cell is selected, then Date and Time Picker control will appear.
However, it did not appear correctly at the specified position all the
times, and usually a "ghostly" image also occur.

Use keyup or keydown event.

Try using doevents right after you display it.

--
Regards,
Tom Ogilvy

"crapit" wrote in message
...
1) How to detect that <enter is press on a editable combobox activeX
control?
From property of combobox, Style is set to DropDownCombo!

2) How to stop ActiveX control Date and Time Picker resize automatically?
As I'm using Worksheet_SelectionChange to detect that if certain range of
cell is selected, then Date and Time Picker control will appear.
However, it did not appear correctly at the specified position all the
times, and usually a "ghostly" image also occur.

If the worksheet contain 8 combobox (activex), do I need to insert keydown
event for each box
"Tom Ogilvy" wrote in message
...
Use keyup or keydown event.

Try using doevents right after you display it.

--
Regards,
Tom Ogilvy

"crapit" wrote in message
...
1) How to detect that <enter is press on a editable combobox activeX
control?
From property of combobox, Style is set to DropDownCombo!

2) How to stop ActiveX control Date and Time Picker resize
automatically?
As I'm using Worksheet_SelectionChange to detect that if certain range
of
cell is selected, then Date and Time Picker control will appear.
However, it did not appear correctly at the specified position all the
times, and usually a "ghostly" image also occur.

Basically yes, although you can create a class module and use it to work for
multiple controls.

John Walkenbach demonstrates the technique using commandbuttons at:
http://j-walk.com/ss/excel/tips/tip44.htm

You can adapt it to your situation.

--
Regards,
Tom Ogilvy

"crapit" wrote in message
...
If the worksheet contain 8 combobox (activex), do I need to insert keydown
event for each box
"Tom Ogilvy" wrote in message
...
Use keyup or keydown event.

Try using doevents right after you display it.

--
Regards,
Tom Ogilvy

"crapit" wrote in message
...
1) How to detect that <enter is press on a editable combobox activeX
control?
From property of combobox, Style is set to DropDownCombo!

2) How to stop ActiveX control Date and Time Picker resize
automatically?
As I'm using Worksheet_SelectionChange to detect that if certain range
of
cell is selected, then Date and Time Picker control will appear.
However, it did not appear correctly at the specified position all the
times, and usually a "ghostly" image also occur.

How about the 2nd problem?

How to stop ActiveX control Date and Time Picker resize automatically?
As I'm using Worksheet_SelectionChange to detect that if certain range
of cell is selected, then Date and Time Picker control will appear.
However, it did not appear correctly at the specified position all the
times, and usually a "ghostly" image also occur.
The worksheet contains only 1 Date and Time Picker for a column. (i.e only 8
rows of date and time is require for the user). Is it better to have
individual Date and Time Picker for each row?

"Tom Ogilvy" wrote in message
...
Basically yes, although you can create a class module and use it to work
for
multiple controls.

John Walkenbach demonstrates the technique using commandbuttons at:
http://j-walk.com/ss/excel/tips/tip44.htm

You can adapt it to your situation.

--
Regards,
Tom Ogilvy

"crapit" wrote in message
...
If the worksheet contain 8 combobox (activex), do I need to insert
keydown
event for each box
"Tom Ogilvy" wrote in message
...
Use keyup or keydown event.

Try using doevents right after you display it.

--
Regards,
Tom Ogilvy

"crapit" wrote in message
...
1) How to detect that <enter is press on a editable combobox
activeX
control?
From property of combobox, Style is set to DropDownCombo!

2) How to stop ActiveX control Date and Time Picker resize
automatically?
As I'm using Worksheet_SelectionChange to detect that if certain
range
of
cell is selected, then Date and Time Picker control will appear.
However, it did not appear correctly at the specified position all
the
times, and usually a "ghostly" image also occur.

I offered DoEvents in the original post. I can't say exactly what problem
you are having, so don't have a pat solution for you.

--
Regards,
Tom Ogilvy


"crapit" wrote in message
...
How about the 2nd problem?

How to stop ActiveX control Date and Time Picker resize automatically?
As I'm using Worksheet_SelectionChange to detect that if certain range
of cell is selected, then Date and Time Picker control will appear.
However, it did not appear correctly at the specified position all the
times, and usually a "ghostly" image also occur.
The worksheet contains only 1 Date and Time Picker for a column. (i.e only
8
rows of date and time is require for the user). Is it better to have
individual Date and Time Picker for each row?

"Tom Ogilvy" wrote in message
...
Basically yes, although you can create a class module and use it to work
for
multiple controls.

John Walkenbach demonstrates the technique using commandbuttons at:
http://j-walk.com/ss/excel/tips/tip44.htm

You can adapt it to your situation.

--
Regards,
Tom Ogilvy

"crapit" wrote in message
...
If the worksheet contain 8 combobox (activex), do I need to insert
keydown
event for each box
"Tom Ogilvy" wrote in message
...
Use keyup or keydown event.

Try using doevents right after you display it.

--
Regards,
Tom Ogilvy

"crapit" wrote in message
...
1) How to detect that <enter is press on a editable combobox
activeX
control?
From property of combobox, Style is set to DropDownCombo!

2) How to stop ActiveX control Date and Time Picker resize
automatically?
As I'm using Worksheet_SelectionChange to detect that if certain
range
of
cell is selected, then Date and Time Picker control will appear.
However, it did not appear correctly at the specified position all
the
times, and usually a "ghostly" image also occur.