LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 145
Default Can Excel do this with coding?

I have a question that I don't know if Excel can handle or not? The final
data entry Column on one of my spreadsheet is a "Comments" section. I use
that Column to enter a variety of client information such as (but not limited
to):

communications between clients and our agency
calls from counselors about our clients
comments regarding disruptive client interactions
reminders regarding action that needs to be taken on a particular client

There is no formula in this column and it is formatted for "general" data
entry. I've seen an Access program which has an "executable" CLICK ON
comments pop up field that can be directly linked to a clients name, and the
user can open a pop up window for reviewing, editing, or inputting additional
comments made. The comments can also be merged with MS Word for printing, as
many comments need to be put on paper for the purpose of a "hard copy" record.

My question is whether or not "coding" can create something similar to what
I described above (a macro button to click on which would open a window for
comments/notes) so I can remove the comments sections (from the two
spreadsheets within my workbook).

Any suggestions on this issue would be greatly appreciated.

Dan
 
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
Requirements to run excel 2000 with VBA coding jigs Setting up and Configuration of Excel 0 November 10th 06 06:05 AM
help with coding in excel associates Excel Worksheet Functions 3 June 7th 06 10:41 AM
Excel Coding Error! Killer Excel Worksheet Functions 9 April 24th 06 01:51 AM
Simple coding in Excel craigs Excel Discussion (Misc queries) 1 January 17th 06 06:48 PM
Color coding the excel sheets Shane Excel Discussion (Misc queries) 3 November 1st 05 04:51 PM


All times are GMT +1. The time now is 03:00 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"