score:0
after further reading i realised that vba simply does not support callback functions out of the box.
using xmlhttp.onreadystatechange is a viable solution but it would require to work around 2 limitations:
1) xmlhttp would have to be declared publicly in order to keep the object's scope available for the "callback" (this is fine).
2) the original function could not return a value so i would have to save the output in a procedure (instead of a "scalar" function that returns the output).
Source: stackoverflow.com
Related Query
- VBA Asynchronous data call with HTTP
- MS Word VBA, trying to populate a combobox with data from an http call
- excel vba call subroutine with variables
- Sending HTTP requests with VBA from Word
- Excel VBA call function with variable name
- VBA Pulling Data with a Schema File
- VBA data validation with user defined function
- Formatting chart data labels with VBA
- Saving Excel data as csv with VBA - removing blank rows at end of file to save
- Add multiple data series to excel chart with VBA
- VBA HTTP GET request - cookies with colons
- VBA call property from with class
- How to populate data from a range (multiple rows and columns) to listbox with VBA
- VBA for...next loop with byte data type not supported?
- Excel VBA Call Shell with quotes in string
- Write large amounts of data at one time with VBA in Access
- Dynamically search for data In an XML file with VBA
- Trying to automatically split data in excel with vba
- Reference only part of an excel table Data Body Range with VBA
- Call python script from vba with wsh
- excel vba http request download data from yahoo finance
- VBA Code for Retrieving PDF Data with Adobe Acrobat Reader
- Scraping data from website with css selectors excel vba
- Can't call Word VBA Macro with parameters
- Fetch data through an API call which requires credentials using Excel VBA
- Convert through vba row with columns of data into column with multiple rows in Excel 2003
- Delete Rows With Duplicate Data VBA
- Deleting data from Access with VBA
- Compare data in 2 columns with VBA or formula
- Save a csv with data in columns using VBA
More Query from same tag
- Sorting lists with keys vba
- All possible uses for the Application.SysCmd Method
- Is there anybody who can help me understand VB code for an XML map on a Word form?
- vba: How can I change the name of a new added workbook in an inactive worksheet?
- Late Binding Word Ribbon
- VBA Timezone issue
- Syntax Error Issue on VBA
- how do i use ADODB connection in vba
- Excel - VBA - Search Array Value in Worksheet
- How to make excel auto-detect are using what is add-in?
- VBA Input Box will not close
- Copy paste shapes from cells
- HTML Tidy for VBA code?
- Save attachments and create sub folders with the names of email subjects
- Run Function down column in Excel VBA
- Excel VBA Textbox time validation to [h]:mm
- Can you pass an array from a Sub into a Form?
- Excel randomly select name from list with multiple entries
- I want to delete Excel rows dynamically
- VBA check each row in a particular column
- How to separate records attached to the same bookmark in different tables?
- How do I create a salary/tax calculator?
- Execute SQL Server stored procedure in VBA with multiple outputs
- Excel VBA: Running a shell script to both change directory and then run a custom script
- Excel Macro that loops within cells and writes to new file
- Saving range as picture with Excel 2016
- Word VBA: How can I jump to the next instance of multiple search terms each time the user presses their shorcut?
- Filter One year date dynamically each time - VBA Macro
- Assign an incoherent range to a variable
- Multiplying range by percentage of days left in current month