![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
New Member
Join Date: Mar 2002
Location: rejdus@hotmail.com
Posts: 18
|
I have an invoice sheet.
In the cell I4 i have a heading JobDetails. What I need now is in next cells bellowI4: I5 I6 I7 ...TO INSERT A COMMENT BOX wheer i can type description of the job. I need to write a macro so it will open automatically while iam entering new invoice and move my cursor to the following cell. I hope this is possible and explains fully wot i am looking for. Plz could any1 suggest something. (if required i can send this part of the project via attachment in email,please) Big up London City |
|
|
|
|
|
#2 |
|
MrExcel MVP
Join Date: Feb 2002
Location: Monterrey, Mexico
Posts: 1,433
|
Do a search on this site for "insert comment", this problem is well documented.
__________________
Kind regards, Al Chara |
|
|
|
|
|
#3 |
|
Board Regular
Join Date: Feb 2002
Posts: 3,065
|
Hi
If you want a code tha adds a cool comment ie clods or some other than boaring box to the active cell on command button please email me on my profile and ill email you it or ask for sheet set up if you want and ill mail it to you, all you do is ckick and edit the data reqd, get you started and loads of guys have had this code. PLEASE i do request if i supply the code you post it on this feed so everyomne can see itm i dont have much of my VBA stuff at home and ill forget. Im sure you understand! A big thanks
__________________
Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you" |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|