Opening Excel in PowerPoint

J

JS

I have an Excel Form that was created with macros and visual basic. It looks
like a form in Access. I have never seen anything set up like this in Excel
before. It has tabs and buttons that analyze data as you enter information.

My question is, is it possible to insert this into a PowerPoint slide and be
able to use for a presentation?

I have tried the Insert | Object in PowerPoint but it will not load to a
slide without receiving some type of error.

Does anyone know if this is possible?
 
T

Tom Ogilvy

Unsure what you specifically mean by form, but if it is a userform.
Try showing the form, then do alt+printscreen to get an image of it in the
clipboard. Paste it into powerpoint.

If it is just a range, then select the range, then hold down the shift key
while you do

Edit=>Copy Picture
 
J

JS

It must be a userform. However I see no data range. All I see is a form
that has multiple buttons and tab pages. When you click on a button a
different page displays.

Even though it has a worksheet, the form floats and it has been sized. My
guess is it operates with Visual Basic.

They want to be able to put in a powerpoint slide and operate like they do
in Excel. My thought was to create a printscreen and include a hyperlink to
the userform. But first I want to make sure they cannot do what they want.
 
T

Tom Ogilvy

Powerpoint has a VBE and Userforms just as Excel does - so possibly they
could do the same thing. In any event, you wouldn't hyperlink directly to a
userform, but to a workbook that when opened will execute code to display the
userform. Without seeing what you are talking about it would be difficult to
understand exactly what you are trying to achieve.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top