Jump to content

Recommended Posts

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 ?

 

Share this post


Link to post
Share on other sites
JLogan3o13

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


√-1 2^3 ∑ π, and it was delicious!

Share this post


Link to post
Share on other sites
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.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-06-01 - Version 1.4.9.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-01-27 - Version 1.3.3.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites
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 !"

 

 

Autoit.png

Share this post


Link to post
Share on other sites
water
Posted (edited)

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 by water

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-06-01 - Version 1.4.9.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-01-27 - Version 1.3.3.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites
water
Posted (edited)

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 by water

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-06-01 - Version 1.4.9.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-01-27 - Version 1.3.3.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×