Thread Tools Display Modes
  #1   Report Post  
Ammon Ammon is offline
Junior Member
Posts: 0
Question Simple but repetitive use of combobox

Hi, my environment is OS WinXP and MSoffice2003, I am fairly novice with VBA, but not completely.

I am a secretary in a dental clinic where each patient receives a diagnostic code. I am creating an EXCEL workbook with 31 worksheets (one for each day of the month), and an end of month total (worksheet 32).

Each of the blank daily worksheets will have activex comboboxes in some blank columns (10 patients or so). Each time a patient name is typed, a corresponding code will be selected from a drop down list on that row (blank rows should return a value of zero).

At the end of the month (worksheet 32), the selected codes from each daily worsheet should display the totals: 100 patients with code 999, 50 patients with code 777, etc.

I'm hoping this is a simple operation, with just repetitive code usage, any advice on how to proceed is welcome! Thanks.
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
repetitive word use ReadAllAboutIt Microsoft Word Help 2 August 20th 08 01:49 AM
Word 2007 Simple (Or not so simple) List Numbering Greg Maxey Microsoft Word Help 2 October 20th 07 06:21 AM
Count repetitive words itgreenwich Microsoft Word Help 5 October 9th 07 07:41 PM
How do I create a macro that will do repetitive tasks? jico Microsoft Word Help 1 January 31st 07 05:33 AM
How do I automate repetitive entries in a template? EricBlaine Microsoft Word Help 2 August 20th 05 12:07 AM

All times are GMT +1. The time now is 09:11 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Word"