LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Code to edit directly in cells from userform

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
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 edit directly in a cell - previously F2 Pweter Excel Discussion (Misc queries) 2 February 18th 10 11:14 AM
edit directly in cell - scroll with mouse Excel_user_M Excel Worksheet Functions 0 January 9th 08 10:30 PM
Edit exsisting data with userform Geo Excel Discussion (Misc queries) 2 October 1st 07 07:38 PM
edit directly in cell in Excel 2007 Andrea New Users to Excel 5 July 8th 06 03:50 PM
Code to edit directly in cells from userform Harald Staff[_4_] Excel Programming 0 September 7th 03 10:09 PM


All times are GMT +1. The time now is 01:53 AM.

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"