Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kilianli
 
Posts: n/a
Default how to use the form in excel


I would like ask how to use the form to input record in the excel sheet
automatically when open the excel , and click the button in the form to
back to the excel sheet.


--
kilianli
------------------------------------------------------------------------
kilianli's Profile: http://www.excelforum.com/member.php...o&userid=32328
View this thread: http://www.excelforum.com/showthread...hreadid=520875

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
davesexcel
 
Posts: n/a
Default how to use the form in excel


kilianli Wrote:
I would like ask how to use the form to input record in the excel sheet
automatically when open the excel , and click the button in the form to
back to the excel sheet.


record a macro opening the form...

place the macro in the workbook open event..


I don't know how or if the form can be displayed on its own,

I am assuming you are talking about the form selection in the data menu


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=520875

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I in excel print consecutive numbers from one form? sjamdavies Excel Discussion (Misc queries) 1 March 8th 06 02:34 AM
How do I build a Home Inspection form in Excel? Mike L. New Users to Excel 1 February 17th 06 10:59 PM
Is there way to enter multiple values into excel cells w/ a form? grassfed Excel Discussion (Misc queries) 1 June 22nd 05 05:26 PM
merge excel form with excel datadase how can i do MY Broblem Excel Worksheet Functions 0 January 11th 05 03:07 AM
How do I set up a field in an Excel form to number it incremental. max Excel Worksheet Functions 1 November 29th 04 10:33 PM


All times are GMT +1. The time now is 07:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"