Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
If you select your data and do Data=Form
this isn't a userform, but will do most of what you describe and doesn't require any coding While I don't know an example to match your description, these provide all the fundamental information you would need: http://support.microsoft.com/?id=168067 XL97: WE1163: "Visual Basic Examples for Controlling UserForms" Microsoft(R) Visual Basic(R) for Applications Examples for Controlling UserForms in Microsoft Excel 97 This Application Note is an introduction to manipulating UserForms in Microsoft Excel 97. It includes examples and Microsoft Visual Basic for Applications macros that show you how to take advantage of the capabilities of UserForms and use each of the ActiveX controls that are available for UserForms http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm Lesson 11: Creating a Custom Form Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step. http://support.microsoft.com/default.aspx?kbid=161514 XL97: How to Use a UserForm for Entering Data http://support.microsoft.com/default.aspx?kbid=213749 XL2000: How to Use a UserForm for Entering Data John Walkenbach's site: http://j-walk.com/ss/excel/tips/userformtips.htm Userform Tips Peter Aiken Articles: watch word wrap. the URL should all be one line. Part I http://msdn.microsoft.com/library/en...uctiontoUserFo rmsPartI.asp Part II http://msdn.microsoft.com/library/en...uctiontoUserFo rmsPartII.asp -- Regards, Tom Ogilvy GUS wrote in message ... I wonder if there is a worksheet or vba example that has a userform and doing the following actions. Bring value to userform.textbox from the selected cell when first run the macro Move from cell to cell with spin button or two buttons (next-previeus) Get value from cell and then edit it trough textbox (similar to the first action) Add row line (above selectedcell) Delete row line (above selectedcell) Fit selected cell contents Add formula to the selected cell Is there any example with all of these (or some of these) as actions in a userform? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I edit directly in a cell - previously F2 | Excel Discussion (Misc queries) | |||
edit directly in cell - scroll with mouse | Excel Worksheet Functions | |||
Edit exsisting data with userform | Excel Discussion (Misc queries) | |||
edit directly in cell in Excel 2007 | New Users to Excel | |||
Code to edit directly in cells from userform | Excel Programming |