Put Formula in VBA

  • Thread starter Thread starter magmike
  • Start date Start date
M

magmike

I have a formula in a column that uses the text from a different
column to provide a value - however, I am hoping that if I use vb to
make the formula, I can enter text into the column the formula
references and therefore only need one column. Is this true? If so,
how would I use this formula in column B in vb to eliminate the need
for column D?

=+HYPERLINK("https://na7.salesforce.com/search/SearchResults?
searchType=1&sen=0&setLast=1&sbstr=" & D4,D4)

Thanks in advance for your help,

magmike
 
I have a formula in a column that uses the text from a different
column to provide a value - however, I am hoping that if I use vb to
make the formula, I can enter text into the column the formula
references and therefore only need one column. Is this true? If so,
how would I use this formula in column B in vb to eliminate the need
for column D?

=+HYPERLINK("https://na7.salesforce.com/search/SearchResults?
searchType=1&sen=0&setLast=1&sbstr=" & D4,D4)

Thanks in advance for your help,

magmike
Click to expand...



I have a formula in a column that uses the text from a different
column to provide a value - however, I am hoping that if I use vb to
make the formula, I can enter text into the column the formula
references and therefore only need one column. Is this true? If so,
how would I use this formula in column B in vb to eliminate the need
for column D?

=+HYPERLINK("https://na7.salesforce.com/search/SearchResults?
searchType=1&sen=0&setLast=1&sbstr=" & D4,D4)

Thanks in advance for your help,

magmike
Click to expand...

FollowHyperlink Method
See AlsoApplies ToExampleSpecificsDisplays a cached document, if it’s already been downloaded. Otherwise, this method resolves the hyperlink, downloads the target document, and displays the document in the appropriate application.

expression.FollowHyperlink(Address, SubAddress, NewWindow, AddHistory, ExtraInfo, Method, HeaderInfo)
expression Required. An expression that returns a Workbook object.

Address Required String. The address of the target document.

SubAddress Optional Variant. The location within the target document. The default value is the empty string.

NewWindow Optional Variant. True to display the target application in a new window. The default value is False.

AddHistory Optional Variant. Not used. Reserved for future use.

ExtraInfo Optional Variant. A String or byte array that specifies additional information for HTTP to use to resolve the hyperlink. For example, youcan use ExtraInfo to specify the coordinates of an image map, the contentsof a form, or a FAT file name.

Method Optional Variant. Specifies the way ExtraInfo is attached. Can beone of the following MsoExtraInfoMethod constants.

MsoExtraInfoMethod type can be one of these MsoExtraInfoMethod constants.
msoMethodGet. ExtraInfo is a String that’s appended to the address.
msoMethodPost. ExtraInfo is posted as a String or byte array.

HeaderInfo Optional Variant. A String that specifies header information for the HTTP request. The defaut value is an empty string.

Example
This example loads the document at example.microsoft.com in a new window and adds it to the History folder.

ActiveWorkbook.FollowHyperlink Address:="http://example.microsoft.com", _
NewWindow:=True
 
Back
Top