I a VB Guru

[Erick de la Torre]

Hy, everyone. I´m trying to show on my Standard form the format cells of Excel(locate into an Excel cell and then push Ctrl+1), I'm using an ole from VB to Excel like this:


'********** I M P O R T A N T
'********** U must have to go to the project references and select the Microsoft Excel 9.0 or 8.0 Object Library

'----------- VB code
Option Explicit
Dim xlsApp As Excel.Application

Private Sub Command1_Click()

Set xlsApp = Excel.Application
With xlsApp
'Show Excel
.Visible = True
'Create a new workbook
.Workbooks.Add
'Put text in to the cell that is selected
.ActiveCell.Value = "123"

'Put text into A3 regardless of the selected cell
.Range("A3").Value = "456"
'----------- VB code

My question is: How can i show the format cells that appears in Excell


Thanx everyone

[da_silvy]

do you mean how to format what the cells look like?