| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Defining a type of the cell
How can I pre-define the type of the cell using VBA?
I need to pre-define the cell type from General to Text, Number or similar, before inputing data within the specified cell... Tnx. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Defining a type of the cell
Range("A1").NumberFormat = "@" 'text
Range("A1").NumberFormat = "#,##0.00" Range("A1").NumberFormat = "General" etc. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "backspace" wrote in message ... How can I pre-define the type of the cell using VBA? I need to pre-define the cell type from General to Text, Number or similar, before inputing data within the specified cell... Tnx. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| defining a name in a cell? | New Users to Excel | |||
| Defining cell with only through 1 - 32 | New Users to Excel | |||
| Defining a Cell for Save as file name | Excel Discussion (Misc queries) | |||
| Defining a cell to name file | Excel Discussion (Misc queries) | |||
| Defining input box data type? | Excel Programming | |||
Linear Mode
