How to use dialog boxes in vba

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

Contact Oscar

You can contact me through this webpage


List all permutations with a condition

2 Responses to “List all permutations with a condition”

  1. Diana says:

    Where is this function?

    ReplaceChrInStr

    Got error when try to run your code.

  2. Oscar says:

    Diana,

    you are right! I forgot a custom function.

    Function ReplaceChrInStr(tmp As String, pos As Single, chr As String)
    Dim str As String, i As Single
    For i = 1 To Len(tmp)
        If i = pos Then
            str = str & chr
        Else
            str = str & Mid(tmp, i, 1)
        End If
    Next i
    ReplaceChrInStr = str
    End Function
    

    Thank you for pointing that out.

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

Contact Oscar

You can contact me through this webpage


Excel – Pivot tables

3 Responses to “Excel – Pivot tables”

  1. Excellent article, Debra!

  2. Oscar says:

    Thank you, Felipe.

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

Contact Oscar

You can contact me through this webpage


TEXTJOIN function

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

Contact Oscar

You can contact me through this webpage


Excel vba – Array variables

2 Responses to “Excel vba – Array variables”

  1. Torstein says:

    Excellent article on a difficult subject, thanks!

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

Contact Oscar

You can contact me through this webpage