DB73
Board Regular
- Joined
- Jun 7, 2022
- Messages
- 107
- Office Version
- 365
- 2021
- 2019
- 2016
- 2010
- 2007
- Platform
- Windows
- Mobile
- Web
Hi peeps,
I have an excel file with a working code and sheet(1) to calculate distance and time between 2 post(zip)codes
i use an google maps API key for that
i have/use an userform to fill in my working hours and travel, it will be saved on a sheet(dump) in the same file.
i also made a matrix with addresses and distance in that file on a different sheet(3).
the userform is only populating the cells on my sheet(dump) with comboxes (from-to) and a formule in a next cell on sheet(dump) finds the distance by a formula index/match
so, my question is,
is it possible to use the same code from my module to run on that userform(textbox or whatever), so it has only the populate the cell on my dump sheet without using the formulas, because the calculation is already done on the userform.
cbx1(from) - cbx2(to) - textbox1(distance)
so the distance has to be calculated on the userform (with or without an action bttn) and then the txtbox should show the travel distance, so i dont need my matrix sheet anymore.
thanks in advance
I have an excel file with a working code and sheet(1) to calculate distance and time between 2 post(zip)codes
i use an google maps API key for that
i have/use an userform to fill in my working hours and travel, it will be saved on a sheet(dump) in the same file.
i also made a matrix with addresses and distance in that file on a different sheet(3).
the userform is only populating the cells on my sheet(dump) with comboxes (from-to) and a formule in a next cell on sheet(dump) finds the distance by a formula index/match
so, my question is,
is it possible to use the same code from my module to run on that userform(textbox or whatever), so it has only the populate the cell on my dump sheet without using the formulas, because the calculation is already done on the userform.
cbx1(from) - cbx2(to) - textbox1(distance)
so the distance has to be calculated on the userform (with or without an action bttn) and then the txtbox should show the travel distance, so i dont need my matrix sheet anymore.
thanks in advance