emina002
07-22-2016, 09:06 AM
I have a listbox in a userform where all the column header from A:AZ listed, I used a name range to capture it. There is no fix data or column header and it could be change from time to time(depend on the user), what I need to to determine is if the vba code detects that the line item is numeric it could format amount into "0,00.00", but date has to be formatted "mm/dd/yyyy". I have also a textbox where the items on listbox will be listed through double clicking.
Is there a way or function inside vba to detect numeric value? Thanks
Is there a way or function inside vba to detect numeric value? Thanks