+ Reply to Thread
Results 1 to 1 of 1

Pass textbox value to two ranges

  1. #1
    Registered User
    Join Date
    04-07-2022
    Location
    Philippines
    MS-Off Ver
    Ms Office 2021
    Posts
    1

    Exclamation Pass textbox value to two ranges

    Hello. I'm a new member here and currently working on a system for school project. It is also my first time working with Excel VBA. Please excuse me if my code is not great.

    Worksheets:
    Sheet1 (2021)
    Sheet2 (2022)
    Sheet3 (Receipt)
    Sheet4 (Database)

    The problem I encountered:
    1. For the COUNT COMMAND BUTTON, the code for counting the customers when the date (from sheet1 and sheet2) is typed in DateTextBox (with format mm/dd/yyyy) and displayed in CountTextBox is running smoothly. However, I want the value displayed in CountTextBox to be passed on sheet4. I add some code and successfully did it for the year 2021 but when I copied this code for year 2022, the value for year 2022 overlapped with the value for year 2021.

    Below is my attached file. Any assistance you can provide would be greatly appreciated.
    Last edited by kim_lerrie; 05-26-2022 at 01:19 AM.

+ 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. Replies: 1
    Last Post: 07-09-2018, 11:57 AM
  2. [SOLVED] Formula to Group analytical data imputed daily into daily weekly and monthly analysis.
    By tianasamour in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-13-2015, 06:10 PM
  3. Replies: 3
    Last Post: 10-01-2013, 05:05 AM
  4. Calculate daily targets given: month, monthly budget, daily indexes
    By Chuckyrp in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-06-2013, 03:30 AM
  5. [SOLVED] [Solved] Convert from daily to monthly income summary
    By androidman in forum Excel General
    Replies: 3
    Last Post: 02-12-2013, 08:44 AM
  6. Replies: 1
    Last Post: 07-11-2008, 05:57 AM
  7. formula for workbook showing daily income compared to goal income.
    By tittytatbratt in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-08-2005, 06:06 PM

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