Originally Posted by
6StringJazzer
Where does the information from the userform go? How does this all work? Walk us through the operational concept.
Good idea, thank you! Allright so the way I see it whenever the user needs to just update the forecast for the existing sites (that's what I would call the lat/lon location) they would just hit the refresh button on the spreadsheet. If for some reason they would need to add more sites then they would click the update button. That's where the userform "control panel" comes in. At this point they will have multiple options, which I divided in different tabs for organization.
The first option, "Add", here they would input the Site Name, which is a custom string the user will use to identify a specific Lat/Cord. Also, in this option they would have to input the Lat/Lon in decimal value. If it's not in decimal value and the site name is not input the person should not be able to go forward, otherwise the query to the API would fail or in the case no "name" is given then the data will be poorly identified. At this point the user will either choose to add changes with the "update" button, clear the information or close the window with the "clear" and "cancel" button respectively. When putting the Site name and Lat/Lon, the Lat/Lon should be added to the API link which for example is this.
The "Site Name" I think would be best to be added next to the site link which is currently found in the "Site List" sheet. This "Site Name" located in the Site List will then be also found on the "Forecast Data" sheet to identify each forecast to the correct location.
For the second option "delete" is self explanatory, on the list box the "site names" will appear in a scrollable box, the user will select one or more of the site names and once the user clicks update the links to the API will get deleted from the "Site List" sheet and therefore be eliminated from the "Forecast Data" sheet once refreshed.
For the third option, "Edit", the user will use the drop down box to select one site to edit and then according to what the person updates, whether it's the "Site Name", Lat, Lon or all that's what would be edited from the "Site List" sheet. Again, once the person hits "Update" the items will be edited and refreshed.
I think it would also be good to add a error catcher. If the user added an invalid lat/lon then the API would fail, the user would see an error message explaining that the lat/lon is invalid when refreshed or as soon as it's edited/added into the workbook.
If there is a simpler way to do this please let me know, this is just the way, I as a user would like to see things working.
Thank you all for your help once again!
Bookmarks