Posts by Wilker12

Hello,

With Worksheet_SelectionChange there is how to know, but if the clicked cell is the same it does not capture. How to make?

Thanks.

Mmm, ok. Thank you.

Hello,

Sometimes Excel chooses to include a single quotation mark at the beginning of the formula ( '= ) and when I type Enter, it says: "We found an error in the formula and tried to correct for: ... Do you accept this correction?". Then he puts the formula, only without space and it does not work. I try to say that the cell is not text and does not solve.

It sometimes works when I copy, paste in Notepad, copy and paste in Excel back. Very strange...

Thanks.

Ok, thank you!

Hello,

Is it possible to read a file on the Internet without Selenium?
Only using commands that VBA already has (such as Open, for example), without having to install add-ons etc...

Thanks!

"3rd party program", exactly.
Tnx.

Yes, Kenneth, they are saved and deleted, after they are attached and sent.
But, for a number of reasons, it would be better to generate and send direct, without saving on the computer.
Thanks.

Hello,

I have a spreadsheet that generates reports in TXT files and sends the files by email...
Is it possible to generate the file and send it directly in the email, without having to save TXT to the computer?

Note: It can not be sent in the email message, it has to be sent as a file, attachment.

Thank you.

"Error"

Hello,
Is it possible to know which object called my function WITHOUT SENDING A VARIABLE to the UDF?
For example:

Sub CheckBox1_Click()
    Call MyFunction
End Sub


Function MyFunction()
    MsgBox "The value of the CheckBox you selected is " & <value object>
End Function

Ok. Tnx.

From what I understand, this allows the use of the "Find" method, which looks in my VBA code if I wrote "Option Base 1" at the top. It is an alternative to reading (and I do not know if this allows changing the value), but I wanted something more straightforward like Application.<...>.Base. Anyway, thank you.

Hello,

Which hierarchy property do I access the current value of the Option Base? Application, Workbooks...
I want to know how to read or change the Option Base at run time.

Thanks.

Quote from shg

Re: Use Trend Worksheetfunction On Vba Array

It's apparently insistent about have all arguments and the returned values asvariants. This works:

Code

Sub test()
Dim knowny As Variant
Dim knownx As Variant
Dim newx As Variant
Dim myval As Variant


knowny = Array(2, 4, 6, 8, 10)
knownx = Array(1, 2, 3, 4, 5)
newx = Array(6)
myval = Application.WorksheetFunction.Trend(knowny, knownx, newx)
End Sub

Display More

Perfect! Thanks.

Hello,

How can I load the values in the Y axis of the graph, direct from my variables by VBA, instead of indicating range of cells in the worksheet?

Thanks.

You solved the issue, XenoCode. Thanks!!

Hello,

In the table, when I insert into any cell value =A1, for example, whenever I change the A1 position the code of another cell is also changed to the new position of A1. Ok, everyone knows, dynamic reference... However, references to A1 in VBA source code is not changed. There is dynamic code too?

Thanks.

Another friend gave me the solution, StephenR. Just add "As Range". Tnx!

Function MyFunction(thecell As Range)      MsgBox thecell.FormulaLocal End Function

(I do not know how to mark this post as SOLVED)

Hello,
I need to create a function to be used in the worksheet and it needs to pass the cell, but it is only passing the value of the cell. Like:
In the table:
A1 has value =UPPERCASE("test1")
B1 has value =MyFunction(A1)

In the module:

Function MyFunction(thecell)
     MsgBox thecell.FormulaLocal
End Function

The function should receive the formula "=MyFunction(A1)", but it gives error. When I change it, it only receives the value "TEST1".
How to make the function pass the cell as an object instead of passing only value?

Thanks.

Perfect, Kenneth! :thumbcoo: