Button to create a new form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the first three lines of my spreadsheet as a header

In row four i have column headings a-z.

I want to have a button in my header that once clicked opens a form from the
range 4a-4z. I have tried to make a macro but it wants to pull it from the
very top and not the specified range i highlight. Is there a macro or code i
need to do to do this?

Thank you for any help or advice you may have.
 
What do you consider as a "Form"?

How did you highlight A4:Z4 when you recorded the macro?

Cannot decipher what you are trying to achieve based upon your explanation.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

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

Similar Threads

Proprietary text on popup buttons 4
Selection.Copy - ActiveSheet.Paste to blank cells 4
macro to sort is missing top row out??? 4
Access create a form calling macros 2
Access Automatically Send a notification email once a record is added 0
Macro Does not Work on Button 4
Form Buttons Connected to a Macro - Want to remove the button 2
Formula or Macro to insert Data in Cell when having more than 7 Functions 2

Back
Top