+ Reply to Thread
Results 1 to 1 of 1

Need help / hints - VBA - For dairy milk entries

  1. #1
    Registered User
    Join Date
    08-22-2021
    Location
    Karachi, Pakistan
    MS-Off Ver
    vba 7.1
    Posts
    1

    Lightbulb Need help / hints - VBA - For dairy milk entries

    Hello dear all,

    I am designing and trying to develop an Excel+VBA based program for my dairy milk business, enabling the user to enter daily shift wise milk produced / fetched under respective buffalor/cow (numbered).
    The objective is to ease twice daily milking activity and avoid errors/ mistakes under manual method and improve / speed up recording, summarizing and reporting.

    Excel xlsm file attached (please enable macros).

    FLOW:

    1) Once excel file is opened, it will show date, shift and shed/barn selection screen
    2) Next is detail or activity entry screen. User has to click on respective animal quantity box for which value to be entered.
    3) Once clicked, that respective quantity box will turn to green (for highlight purpose only) and a new screen will appear to enter the milk quantity value
    4) Once a valid quantity value is entered and added, it will be shown under respective animal's quantity box on detail or activity entry screen


    CURRENTLY FACING PROBLEM:

    a) How to identify which quantity box is currently green, so that after entering a valid value it color should be changed from green to normal (like all other).
    Turning all label boxes 1 by 1 is very hectic and resource consuming way.. What could be a smart and efficient way?

    Kindly share thoughts / hints.


    Excel xlsm file attached (please enable macros).
    Attached Files Attached Files
    Last edited by Aamir Saeed; 08-22-2021 at 02:23 PM. Reason: Improving understanding

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Porting VBA to MAC - pointers and hints.
    By PhilB2 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 01-18-2021, 04:44 AM
  2. Excel templates for milk vendor
    By kota.rsp in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-08-2018, 02:13 PM
  3. [SOLVED] Can i create daily dairy on excel or access?
    By m.shahbaz in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 01-11-2017, 03:55 PM
  4. A novice looking for guildance and any helpful hints
    By shadowlord in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 01-24-2013, 01:13 AM
  5. THIS WILL BE LEGEN... wait for it... DAIRY! MOO!
    By headstrong2740 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 08-02-2012, 09:18 PM
  6. No Cookies and Milk for Santa
    By scaffdog845 in forum The Water Cooler
    Replies: 0
    Last Post: 12-23-2009, 12:50 PM
  7. [SOLVED] Why no hints after typing .
    By Mike NG in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-23-2005, 04:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1