User Form Buttons

[Matt5353]

I have a user form that has 12 Bottons on it 8, 10, 12, 14, 16 ,18, 20, 22, 24, 26, 28, 30.
These number represent how many players or teams that are going to play a game.
I want to add to each button a workbook that has all the imformation needed.
So when I press button 8 the workbook that is associated with 8 players comes up or if I press 30 that workbook opens etc.
Andrew

 

[Trebor76]

Hi Andrew,

This will open a workbook called "My File.xlsx" in the "C:" directory (change to suit):

Option Explicit
Sub Macro1()

    Dim wb As Workbook
    
    Set wb = Workbooks.Open("C:\My File.xlsx")
    
End Sub

One question - why have different different workbooks for the number of players / teams? Can you not just have a single workbook with the maximum number of tabs (30) and just hide the number of tabs based on the button clicked? So if 14 was clicked the workbook would open and 16 of the tabs would be hidden (this is assuming that the number represents individual tabs of course).

HTH

Robert

 

[Matt5353]

In each work book i have 6 sheets representing a sequence of games. There are 5 rounds of games to determine a winner at the end of the day. if i put it into one work book i wouls have approx 70-80 sheets.

 

[Waimea]

Hi, can you upload a sample file?

 

[Trebor76]

if i put it into one work book i would have approx 70-80 sheets.

Though I'm not a fan of workbooks with a large number of tabs, Excel could handle that no problem. Having one workbook would also make maintenance easier but it's up to you.

can you upload a sample file

You would have to host the file somewhere and provide a link to it as MrExcel doesn't have workbook attachment capability.

Regards,

Robert

 

[Matt5353]

Can you give me your email and I will send it directly to you to view.

 

[Matt5353]

Merry Xmas hope your day went well.
If you can supply me your email address I can certainly upload a file to you.
Hey and thanks for the help by the way.
Andrew (Matt5353)