The Form option
Hi,
I have a largish spreadsheet with many column headings (about 30), i know of the form option as an easy way of changing information or putting new information in to the spreadsheet, however, what I would really like to do is for the user to access this form by pressing a button on another sheet, so that the list criteria are already put in and all she has to do is enter the information she requires! Is this possible?? |
The Form option
Are you talking about the Data=Form
worksheets("Sheet1").Activate worksheets("sheet1").ShowDataForm -- Regards, Tom Ogilvy "kirbster1973" wrote in message ... Hi, I have a largish spreadsheet with many column headings (about 30), i know of the form option as an easy way of changing information or putting new information in to the spreadsheet, however, what I would really like to do is for the user to access this form by pressing a button on another sheet, so that the list criteria are already put in and all she has to do is enter the information she requires! Is this possible?? |
The Form option
Perfect,
Thankyou very much, I really am a novice with Macros, knew it would be simple. Regards RIchard "Tom Ogilvy" wrote: Are you talking about the Data=Form worksheets("Sheet1").Activate worksheets("sheet1").ShowDataForm -- Regards, Tom Ogilvy "kirbster1973" wrote in message ... Hi, I have a largish spreadsheet with many column headings (about 30), i know of the form option as an easy way of changing information or putting new information in to the spreadsheet, however, what I would really like to do is for the user to access this form by pressing a button on another sheet, so that the list criteria are already put in and all she has to do is enter the information she requires! Is this possible?? |
All times are GMT +1. The time now is 10:57 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com