hi. i would like to create an inputbox that shows the existing formula in a selected cell and from the inputbox i too can edit the formula. can this be ok?? Thanks.
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
-
inputbox that shows formula & edit formula purpose (excel 2002)
Home » Forums » AskWoody support » Productivity software by function » Visual Basic for Applications » inputbox that shows formula & edit formula purpose (excel 2002)
- This topic has 26 replies, 4 voices, and was last updated 20 years, 7 months ago.
Viewing 0 reply threadsAuthorReplies-
WSHansV
AskWoody Lounger -
WSboat
AskWoody Lounger -
WSHansV
AskWoody LoungerNovember 8, 2004 at 12:49 pm #896969This code isa only a small variation on my reply to your post 423089 from last week. If you click in the word InputBox (in the Visual Basic Editor) and press F1, you’ll get help for this method, and an example. You can use the online help to learn how to adapt the code further.
-
WSHansV
AskWoody LoungerNovember 8, 2004 at 12:49 pm #896970This code isa only a small variation on my reply to your post 423089 from last week. If you click in the word InputBox (in the Visual Basic Editor) and press F1, you’ll get help for this method, and an example. You can use the online help to learn how to adapt the code further.
-
WSboat
AskWoody Lounger -
WSHansV
AskWoody LoungerNovember 8, 2004 at 1:42 pm #896985The online help is installed as part of Microsoft Office. You can obtain help in several ways in the Visual Basic Editor:
– Select Help | Microsoft Visual Basic Help.
– Click in a word in a module, and press F1.
– Activate the Object Browser (F2), enter a search term, press Enter, click on one of the listed items, press F1. -
WSboat
AskWoody LoungerNovember 8, 2004 at 4:35 pm #897065Hi Hans. Thanks. now i realise the comma marks in the InputBox() are the 8 information input into the dialog box. and the real input by the user is the Default info and its Type is goes with the Default info. others are optional with compulsory wordings in the Prompt info. Thanks.
about the inputbox, where i edit my formula, without clicking the formula with mouse at the place i desire to edit, can the edit function be done with by typing any keys relevent in the keyboard? any keyboard keys can too edit my formula in the input dialog box without using mouse? the formula displayed at active cell is auto highlighted with black color and if i hit left,right,top, or bottom, it won’t be right. any keys to edit without disturbing the original formula?
Thanks again. -
WSHansV
AskWoody Lounger -
WSboat
AskWoody LoungerNovember 12, 2004 at 3:57 pm #899178Hi Hans. yes, i can explain again about using keyboard to edit inputbox. when the inputbox appears in my pc screen asking to edit formula, i have to edit by clicking the place i want to edit using mouse. i cannot find ways to edit using keyboard. with keyboard, i can move to left and right freely to edit my formula in inputbox. with mouse, i can edit my formula by clicking at the exact place i want to edit because if i move the cursor with keyboard, the formula gets edited of unwanted cells address. with long formula that extends unseen in the display inputbox, editing using mouse can be with some extra efforts, like i edit a ‘dummy’ key at the end of the inputbox to get the remaining formula seen and delete the dummy key later before real editing comes in. i hope my explanation makes sense. thanks. bye.
-
WSboat
AskWoody LoungerNovember 12, 2004 at 3:57 pm #899179Hi Hans. yes, i can explain again about using keyboard to edit inputbox. when the inputbox appears in my pc screen asking to edit formula, i have to edit by clicking the place i want to edit using mouse. i cannot find ways to edit using keyboard. with keyboard, i can move to left and right freely to edit my formula in inputbox. with mouse, i can edit my formula by clicking at the exact place i want to edit because if i move the cursor with keyboard, the formula gets edited of unwanted cells address. with long formula that extends unseen in the display inputbox, editing using mouse can be with some extra efforts, like i edit a ‘dummy’ key at the end of the inputbox to get the remaining formula seen and delete the dummy key later before real editing comes in. i hope my explanation makes sense. thanks. bye.
-
WSHansV
AskWoody LoungerNovember 13, 2004 at 2:19 pm #899535Perhaps you should change
varResult = Application.InputBox(“Edit the formula”, , ActiveCell.Formula, , , , , 0)
to
varResult = InputBox(“Edit the formula”, , ActiveCell.Formula)
You will lose the ability to use the mouse to point to cells, but you can use the keyboard, including the arrow keys.
-
WSboat
AskWoody Lounger -
WSboat
AskWoody Lounger -
WSHansV
AskWoody LoungerNovember 13, 2004 at 2:19 pm #899536Perhaps you should change
varResult = Application.InputBox(“Edit the formula”, , ActiveCell.Formula, , , , , 0)
to
varResult = InputBox(“Edit the formula”, , ActiveCell.Formula)
You will lose the ability to use the mouse to point to cells, but you can use the keyboard, including the arrow keys.
-
WSHansV
AskWoody Lounger -
Andrew Lockton
AskWoody_MVPNovember 9, 2004 at 9:56 pm #897615Boat
The inputbox command that Hans has suggested is modeless so using the keyboard is either going to wipe the current selection or move around the excell cells in the background. I couldn’t find a way to unselect the formula (without the mouse) in the inputbox dialog so I think you may have to find another way to display the cell contents.
Is there a reason you don’t want to use the formula bar to edit the cell contents?
-
WSboat
AskWoody LoungerNovember 12, 2004 at 10:59 am #898978hi Andrew. Thanks for your reply. yes, i understand. your experience same with me. since i use the macros, (about 30 minutes run macros), i use keyboard shortcut to use them, i press Alt + a small letter key to run macro, writing formulas using keyboard, copy&paste function use keyboard, except editing formulas (using the mouse require point the cursor at end of formula, which i realise the formula gets unseen in the inputbox since it is long. so what do i do to edit the formula? i point mouse cursor at the end of inputbox where there is first part of whole formula, press ‘+’ sign to get the ‘behind’ part formula, delete the “+” sign, use mouse carefully precise cursor at end formula and & use keyboard to key formula). and i realise using keyboard to edit formula in inputbox (if that realised) i can move right left cursor freely).
i use keyboard, in fact faster i realise. and have fingers exercise. (my hand feels stiff using mouse, and gets warm holding it longer, especially there is one optical). THANKS. any suggestion? THANKS.
-
WSboat
AskWoody LoungerNovember 12, 2004 at 10:59 am #898979hi Andrew. Thanks for your reply. yes, i understand. your experience same with me. since i use the macros, (about 30 minutes run macros), i use keyboard shortcut to use them, i press Alt + a small letter key to run macro, writing formulas using keyboard, copy&paste function use keyboard, except editing formulas (using the mouse require point the cursor at end of formula, which i realise the formula gets unseen in the inputbox since it is long. so what do i do to edit the formula? i point mouse cursor at the end of inputbox where there is first part of whole formula, press ‘+’ sign to get the ‘behind’ part formula, delete the “+” sign, use mouse carefully precise cursor at end formula and & use keyboard to key formula). and i realise using keyboard to edit formula in inputbox (if that realised) i can move right left cursor freely).
i use keyboard, in fact faster i realise. and have fingers exercise. (my hand feels stiff using mouse, and gets warm holding it longer, especially there is one optical). THANKS. any suggestion? THANKS.
-
Andrew Lockton
AskWoody_MVPNovember 9, 2004 at 9:56 pm #897616Boat
The inputbox command that Hans has suggested is modeless so using the keyboard is either going to wipe the current selection or move around the excell cells in the background. I couldn’t find a way to unselect the formula (without the mouse) in the inputbox dialog so I think you may have to find another way to display the cell contents.
Is there a reason you don’t want to use the formula bar to edit the cell contents?
-
WSpieter
AskWoody LoungerNovember 11, 2004 at 10:17 am #898451 -
WSboat
AskWoody Lounger -
WSboat
AskWoody Lounger -
WSpieter
AskWoody LoungerNovember 11, 2004 at 10:17 am #898452 -
WSHansV
AskWoody LoungerNovember 8, 2004 at 1:42 pm #896986The online help is installed as part of Microsoft Office. You can obtain help in several ways in the Visual Basic Editor:
– Select Help | Microsoft Visual Basic Help.
– Click in a word in a module, and press F1.
– Activate the Object Browser (F2), enter a search term, press Enter, click on one of the listed items, press F1.
-
-
-
WSboat
AskWoody Lounger
-
-
WSboat
AskWoody LoungerViewing 0 reply threads -

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
Windows Spotlight broken on Enterprise and Pro for Workstations?
by
steeviebops
6 hours, 14 minutes ago -
Denmark wants to dump Microsoft for Linux + LibreOffice
by
Alex5723
7 hours, 41 minutes ago -
How to get Microsoft Defender to honor Group Policy Setting
by
Ralph
6 hours, 51 minutes ago -
Apple : Paragon’s iOS Mercenary Spyware Finds Journalists Target
by
Alex5723
16 hours, 59 minutes ago -
Music : The Rose Room – It’s Been A Long, Long Time album
by
Alex5723
18 hours, 5 minutes ago -
Disengage Bitlocker
by
CWBillow
8 hours, 3 minutes ago -
Mac Mini M2 Service Program for No Power Issue
by
Alex5723
20 hours, 5 minutes ago -
New Win 11 Pro Geekom Setup questions
by
Deo
4 hours, 46 minutes ago -
Windows 11 Insider Preview build 26200.5651 released to DEV
by
joep517
1 day, 3 hours ago -
Windows 11 Insider Preview build 26120.4441 (24H2) released to BETA
by
joep517
1 day, 3 hours ago -
iOS 26,, MacOS 26 : Create your own AI chatbot
by
Alex5723
1 day, 7 hours ago -
New PC transfer program recommendations?
by
DaveBoston
2 hours, 39 minutes ago -
Windows 11 Insider Preview Build 22631.5545 (23H2) released to Release Preview
by
joep517
1 day, 11 hours ago -
Windows 10 Build 19045.6029 (22H2) to Release Preview Channel
by
joep517
1 day, 11 hours ago -
Best tools for upgrading a Windows 10 to an 11
by
Susan Bradley
23 hours, 42 minutes ago -
The end of Windows 10 is approaching, consider Linux and LibreOffice
by
Alex5723
3 hours, 45 minutes ago -
Extended Windows Built-in Disk Cleanup Utility
by
bbearren
12 hours, 39 minutes ago -
Win 11 24H2 June 2025 Update breaks WIFI
by
dportenlanger
2 days, 6 hours ago -
Update from WinPro 10 v. 1511 on T460p?
by
CatoRenasci
1 day, 4 hours ago -
System Restore and Updates Paused
by
veteran
2 days, 8 hours ago -
Windows 10/11 clock app
by
Kathy Stevens
1 day, 19 hours ago -
Turn off right-click draw
by
Charles Billow
2 days, 12 hours ago -
Introducing ChromeOS M137 to The Stable Channel
by
Alex5723
2 days, 15 hours ago -
Brian Wilson (The Beach Boys) R.I.P
by
Alex5723
14 minutes ago -
Master patch listing for June 10, 2025
by
Susan Bradley
2 days, 17 hours ago -
Suggestions for New All in One Printer and a Photo Printer Windows 10
by
Win7and10
1 day, 20 hours ago -
Purchasing New Printer. Uninstall old Printer Software First?
by
Win7and10
2 days, 23 hours ago -
KB5060842 Issue (Minor)
by
AC641
1 day, 11 hours ago -
EchoLeak : Zero Click M365 Copilot leak sensitive information
by
Alex5723
3 days, 6 hours ago -
24H2 may not be offered June updates
by
Susan Bradley
1 day, 22 hours ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.