VBA userform_Get从附加文本框到单元格的值(VBA userform_Get Value from additional textboxes to cells)

 那是因为你只在密钥代码上运行它... 
 
 把它放在一个像这样的功能.... 
 
    function getMiles(){
    var firstValue = parseFloat($('#first').val()); // get value of field
    var secondValue = parseFloat($('#second').val()); // convert it to a float
    var thirdValue = parseFloat($('#third').val());
    $('#added').html(firstValue * secondValue ); 

    }
 
 然后你就可以在keyup上运行那些代码，只要它改变....并且只需要在任何其他时间运行它....就像页面加载时... 
 
$('input').keyup(getMiles); //this will do as you had it before...


 getMiles();//this can be used at top of script, or in a callback, 
            //so that it updates on page load, or on the google map callback 
 
 例如，我不知道你是如何从谷歌获取数据的，但是让我们假装它是一个Jquery Ajax调用....那么你只需要在成功函数中调用getMiles() ....就像这样.. 。 
 
$.ajax({
   url: "googlemapexample.php",
   dataType: "json",
   success: getMiles
   });
 
 或者在完成功能....所以你可以做scuccess上的其他东西.... 
 
    $.ajax({
   url: "googlemapexample.php",
   dataType: "json",
   success: function(data){
    ///do some stuff here with data
    } }).done(getMiles);

Thats because you only have it running on the keyup code...
 
put it in a function like so....
 
    function getMiles(){
    var firstValue = parseFloat($('#first').val()); // get value of field
    var secondValue = parseFloat($('#second').val()); // convert it to a float
    var thirdValue = parseFloat($('#third').val());
    $('#added').html(firstValue * secondValue ); 

    }
 
Then you can run that code, on keyup for anytime it changes....and just run it any other time you need to....like when page loads etc...
 
$('input').keyup(getMiles); //this will do as you had it before...


 getMiles();//this can be used at top of script, or in a callback, 
            //so that it updates on page load, or on the google map callback 
 
Like for example, I don't know how you are getting the data from google, but lets pretend its a Jquery Ajax call....then you would just call getMiles() in the success function....like this...
 
$.ajax({
   url: "googlemapexample.php",
   dataType: "json",
   success: getMiles
   });
 
Or in the done function....so you can do other stuff on scuccess....
 
    $.ajax({
   url: "googlemapexample.php",
   dataType: "json",
   success: function(data){
    ///do some stuff here with data
    } }).done(getMiles);