Hi,
I want to export data from a listbox into excel app using xojo.
I want to put color in excel’s cell with specific criteria using IF function.
will it possible to do it with xojo excel plugin?
I have check on the web, excel macros vba can do this. But the problem is, I dont know how to execute/run an excel macro while exporting the data from listbox.
the vba code that I have found on the web
Dim myRng As Range
Set myRng = ActiveSheet.Range("A1: F33")
For Each Cell In myRng
If Cell.Value = "Price" Then Cell.Interior.ColorIndex = 35
If Cell.Value = "" Then Cell.Interior.ColorIndex = xlNone
Next Cell
any help?
thanks
arief