$$Excel-Macros$$ Re: Uncertain number of input for VBA function

Since no one is asswering my question, may be people do not understand it. Let me give more example. Usually, we use a fixed number of parameters/inputs or a range for a UDF. Example: Function xyz(a as double, b as double) as double xyz = a + b End Function Or Function xyz(rng a

$$Excel-Macros$$ Why I cannot call the textbox control value this way?

ts("Sheet2") sht2 .Range("A1") = Worksheets("Sheet1").TextBox1.Value The above code works fine. My question is originally I have the following code instead of the last line: sht2 .Range("A1") = sht1.TextBox1.Value and i