DB73
Board Regular
- Joined
- Jun 7, 2022
- Messages
- 107
- Office Version
- 365
- 2021
- 2019
- 2016
- 2010
- 2007
- Platform
- Windows
- Mobile
- Web
HI,
I'm struggling with the following;
i have a sheet called dumpstats that filled in via a userform
also got a sheet with data (tables) for populating the comboboxes on that userform
problem for me to solve;
i want to format the cells on the dumpstats sheet in currency (€)
i selected the column (AR) on dumpstats and set on currency.
but when cells are filled by the comboboxes the cells gettin a fault message because its filled with text and not with a number.
I use this code to write the combobox value to dumpstats sheet;
combobox gets populated by this code;
the tables on the data sheets are not formatted. (does it have too ?)
only thing is, i see 46,8 instead of 46,80
I know that the comboboxes are "text"
so it doesnt matter, i think, what format these cells have.
thanks in advance.
I'm struggling with the following;
i have a sheet called dumpstats that filled in via a userform
also got a sheet with data (tables) for populating the comboboxes on that userform
problem for me to solve;
i want to format the cells on the dumpstats sheet in currency (€)
i selected the column (AR) on dumpstats and set on currency.
but when cells are filled by the comboboxes the cells gettin a fault message because its filled with text and not with a number.
I use this code to write the combobox value to dumpstats sheet;
VBA Code:
Range("AR" & Rows.Count).End(xlUp).Offset(0, 0).Value = ComboBox16.Value
combobox gets populated by this code;
VBA Code:
ComboBox16.List = Application.Range("overige_declaratie").Value
the tables on the data sheets are not formatted. (does it have too ?)
only thing is, i see 46,8 instead of 46,80
I know that the comboboxes are "text"
so it doesnt matter, i think, what format these cells have.
thanks in advance.