Excel Code From Access

[DMT Dave]

Hi Guys, I am using the following code on a Excel Work Sheet,

is there a method to add this from Access as i am creating a new file each day, this would be helpful ???

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
Target.Interior.ColorIndex = 3
End Sub

NEXT SHEET CELL COLOUR



Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
Target.Interior.ColorIndex = 4
End Sub

[ranman256]

access wont work that way. it wont work on datasheet.

you CAN put interior color on a form text box,
but at GOT FOCUS, LOST FOCUS. Access does not have beforeRightClick.

[DMT Dave]

Do you mean i can do something like on FormOpen me.txtGreen.BackColour = 3

Then within the xlApp and xlWS something like

.Worksheets(1).Columns("C10:C10").BackColour = Me.txtGreen
??

Many Thanks

[June7]

Code in Access VBA can open and manipulate Excel objects. Review http://www.accessmvp.com/KDSnell/EXCEL_MainPage.htm

However, referencing a textbox like that will only be helpful if the textbox has a value that can translate to a color code because Value is default property and your code does not specify any property.