Run a dialog sheet from another dialog sheet

S

shajueasow

Well-known Member

Joined

Oct 7, 2004

Messages

1,926

• Dec 14, 2005

• #2

Hi,
Welcome to the board.
If you have a sheet with your required dialog then try putting in the macro:
Sheets("Your particular sheet name").select

AND for showing an userform while you open a file put in the Workbook Open event
userform1.show (substitue userform1 with your userform's name)

 

Upvote 0

Norie

Well-known Member

Joined

Apr 28, 2004

Messages

76,377

Office Version

1. 365

Platform

1. Windows

• Dec 14, 2005

• #3

Do you mean dialog sheets from Excel 5.0?

This is how you use VBA to run a dialog sheet.

Code:

DialogSheets("Dialog2").Show

What you could do is create a macro with that code and assign it to a button on another dialog sheet.

 

Upvote 0

J

jeturner

New Member

Joined

Dec 14, 2005

Messages

7

• Dec 14, 2005

• #4

thanks for your reply but is it possible to run the dialog, rather than just selecting it
sorry for not clarifying

 

Upvote 0

J

jeturner

New Member

Joined

Dec 14, 2005

Messages

7

• Dec 14, 2005

• #5

Norie said:

Do you mean dialog sheets from Excel 5.0?

This is how you use VBA to run a dialog sheet.

Code:

DialogSheets("Dialog2").Show

What you could do is create a macro with that code and assign it to a button on another dialog sheet.

Click to expand...

thanks norie thats what i needed

 

Upvote 0

Norie

Well-known Member

Joined

Apr 28, 2004

Messages

76,377

Office Version

1. 365

Platform

1. Windows

• Dec 14, 2005

• #6

No problem.

Can I ask why you are using dialog sheets?

 

Upvote 0

J

jeturner

New Member

Joined

Dec 14, 2005

Messages

7

• Dec 14, 2005

• #7

i am creating a multi purpose worksheet for a computer illiterate friend to manage things such as his contacts and money
so am using a user friendly approach for him
but rather than have one huge dialog i wanted to split it up into many smaller ones

 

Upvote 0

Norie

Well-known Member

Joined

Apr 28, 2004

Messages

76,377

Office Version

1. 365

Platform

1. Windows

• Dec 14, 2005

• #8

Why not use userforms?

Dialog worksheets are from Excel 5.0 and are, as far as I know, only included in later versions for backward compatibility.

 

Upvote 0

J

jeturner

New Member

Joined

Dec 14, 2005

Messages

7

• Dec 14, 2005

• #9

i am only using dialog sheets because i have recently covered them at school, so understand them easily, havent used userforms as yet

 

Upvote 0

Norie

Well-known Member

Joined

Apr 28, 2004

Messages

76,377

Office Version

1. 365

Platform

1. Windows

• Dec 14, 2005

• #10

They teach dialog sheets in school?

Like I said they're from Excel 5.0 which is more than 10 years old.

I've been working with Excel for a fair number of years and I've never come across them being used.

In fact the only place I see them mentioned is on this forum.

I don't actually know a lot about dialog sheets but I would imagine userforms might have more flexibility/functionality.

 

Upvote 0