Search:

Type: Posts; User: Haluk_; Keyword(s):

Search: Search took 0.00 seconds.

  1. Replies
    10
    Views
    284

    Re: Form Control OptionButtons Calculation

    http://i63.tinypic.com/2agm0ps.png
  2. Replies
    10
    Views
    284

    Re: Form Control OptionButtons Calculation

    Did you download the file itself ?

    .
  3. Replies
    16
    Views
    744

    Re: Creating an dynamic array from 3 parameters

    Ignore the previous code and try this;


    Sub Test()
    Dim myArr(1 To 8)
    a = 5000
    b = 2
    c = 7

    temp = a
  4. Replies
    16
    Views
    744

    Re: Creating an dynamic array from 3 parameters

    Maybe this;


    Sub Test()
    Dim myArr(1 To 7)
    a = 5000
    b = 2
    c = 7

    temp = 5000
  5. Replies
    10
    Views
    284

    Re: Form Control OptionButtons Calculation

    You check the file given in the link below;

    https://drive.google.com/open?id=1bydtK3RRcnM9VPxK06SplsrbXdyLNj0T

    As a summary; the Option Buttons are linked to the cell P3 and there is a small...
  6. Replies
    10
    Views
    284

    Re: Form Control OptionButtons Calculation

    What do you expect to get as a result if you choose 1, 2 and 3 ?

    .
  7. Replies
    3
    Views
    308

    Re: Macro to open Abode Reaader

    I couldn't edit my post :confused::confused:

    Using the PicPath variable;


    Sub Test()
    PicPath = "C:\TestFolder\myFile.pdf"
    ActiveWorkbook.FollowHyperlink PicPath
    End Sub
  8. Replies
    3
    Views
    308

    Re: Macro to open Abode Reaader

    The following simple code may help you;


    Sub Test()
    PicPath = "C:\TestFolder\myFile.pdf"
    ActiveWorkbook.FollowHyperlink "C:\TestFolder\myFile.pdf"
    End Sub
  9. Replies
    2
    Views
    133

    Re: Copy Paste Last Row VBA

    BTW;


    Wk_Name = ThisWorkbook.Name

    should be the second line. May be this fault is because of the browser i am using (Chrome)
  10. Re: If Chip Pearson's website ever helped you, please jot a note...

    He was one of the legends of the Excel world. I am so sad .....

    My sincere condolences to his family and friends.
  11. Replies
    2
    Views
    133

    Re: Copy Paste Last Row VBA

    Check the code below code, take care of the changes marked with red font and ammend it to suit your needs.


    Sub CopiaDetalle() Wk_Name = ThisWorkbook.Name
    Ultimafila =...
  12. Re: vba to reorder last,first name in same cell

    You could easily remove the comma sign from my code, which comes as;


    Sub Test()NoA = Range("A" & Rows.Count).End(xlUp).Row
    For i = 2 To NoA
    Range("A" & i) =...
  13. Re: vba to reorder last,first name in same cell

    An alternative;


    Sub Test() NoA = Range("A" & Rows.Count).End(xlUp).Row
    For i = 2 To NoA
    Range("A" & i) = Trim(StrReverse(Split(StrReverse(Range("A" & i)), ",")(0)) & ", " _
    ...
  14. Replies
    6
    Views
    239

    Re: VBA Pull out Currency from string

    This UDF may help you;


    Function getAmount(str As String)
    With CreateObject("VBscript.RegExp")
    .Global = True
    .Pattern = "\$\d+(\,\d+)?"
    On Error Resume Next
    ...
Results 1 to 14 of 14