Consulting

Results 1 to 2 of 2

Thread: Solved: Passing values from Userform

  1. #1
    VBAX Expert TrippyTom's Avatar
    Joined
    Jul 2005
    Location
    New York, NY (USA)
    Posts
    556
    Location

    Solved: Passing values from Userform

    I want to pass two values from a userform I created into a procedure I have to make a table. Based on this link: http://msdn.microsoft.com/library/de...HV05194031.asp ... I think I'm close, but I'm missing something because the form isn't showing up.

    [vba]
    Option Explicit
    Public formCols As Integer
    Public formRows As Integer
    ...[/vba]

    [vba]
    frm_myTable.Show

    mySlide = ActiveWindow.View.Slide.SlideIndex
    MsgBox ("Cols: " & formCols & ", Rows: " & formRows)

    Set tb = ActivePresentation.Slides(mySlide).Shapes.AddTable(numRows:=formRows, NumColumns:=formCols, Left:=50, Top:=300, Width:=100, Height:=100)
    ...


    [/vba]

  2. #2
    VBAX Expert TrippyTom's Avatar
    Joined
    Jul 2005
    Location
    New York, NY (USA)
    Posts
    556
    Location
    omg i'm dumb!
    I had the sub marked as Private.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •