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