Combolist in XLS

[Ebola57]

Hi all

I'd like to choose a value from a combobox set in a cell of Excel ' sheet

(Outlook_ex.au3 doesn't permit this)

I think I have to work with object, but no idea of what to do with the sheet ...

Any suggestion please ?

 

[JLogan3o13]

Look at the Excel functions in the help file. You could also provide an example spreadsheet for us to look at.

[water]

Example:

_Excel_RangeValidate($oWorkbook, Default, "A1:A10", $xlValidateList, "Yes;No;Don't know")

Only allows values Yes, No, Don't know in cells A1 to A10.

[Ebola57]

I missexplained my problem. I simply want to 'pick' a valu from the combolist

In the original example, I'd like to selecte "Yes !"

 

 

[water]

I see.
Then use _Excel_FilterGet and extract the data from the returned array.

Wrong answer. Need to check how to get the result of _Excel_RangeValidate.

Edited March 9, 2018 by water

[water]

Use

Global $sValidate = $oWorkbook.Activesheet.Range("A1").Validation.Formula1
ConsoleWrite($sValidate & @CRLF)

to get the validation of cell "A1".
Then use StringSplit to get the desired value.

Edited March 10, 2018 by water