How to Fix a Kernel32.DLL Error? : How to Resolve - Date formatting in a combo box (Excel 2007)?

Monday, September 26, 2016

Date formatting in a combo box (Excel 2007)

I've placed an ActiveX ComboBox in a cell of Worksheet "A".
On Worksheet "B" I've populated a column, formatted as "Date", with 365 dates (created by entering a few and dragging to autofill the rest of the values.) The dates appear in DD/MM/YY format
as desired.
The ListFillRange property for the ComboBox on Worksheet "A" is set to the range on Worksheet "B", and it correctly populates the list when opened.
The dates in the list also appear in DD/MM/YY format as desired.
PROBLEM: Upon selecting a date from the list, it shows in the field as its serial date equivalent.
QUESTION: How can I make the selected date display to the user in DD/MM/YY format?

Keys to the Problem Date formatting in a combo box (Excel 2007)

Download Error Fixer (Free)

hi
the default format for combo box is text so the combo box is stripping off the number format.
in design mode, right click the combo box then click view code.
paste this line .

Private Sub ComboBox1_Change()
ComboBox1.Value = Format(ComboBox1.Text, "dd/mm/yy")
End Sub

make any name or format changes as needed.
regards
FSt1

Make Sure that your Hardware Meets the System Requirements

Microsoft Windows Requirements :

1 gigahertz (GHz) or faster 32-bit (x86) or 64-bit (x64) processor
1 gigabyte (GB) RAM (32-bit) or 2 GB RAM (64-bit)
16 GB available hard disk space (32-bit) or 20 GB (64-bit)

This error can be due to some configuration requirements for you system. If your PC hardware is not up to par, then make sure you upgrade where necessary before continuing.

Recommended Method to Fix the Problem: Date formatting in a combo box (Excel 2007):

How to Fix Date formatting in a combo box (Excel 2007) with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your system. Run it, and it will scan your system. The junk files will be shown in the list.