Consulting

Results 1 to 4 of 4

Thread: General VBA Inquiry

  1. #1

    General VBA Inquiry

    Hello,

    I am trying to figure out if it is possible to control which sheet that data is added, modified, & deleted by using the value from a single combo box to specify which sheet needs to be used. Also the combo box needs to display the data on the specific sheet in a list box.

    The project I am working on I have been able to put all the data into single sheet and filter it that way with the combo box. However it makes the database unorganized and by the end several thousand entries long.

    Any suggestions or thoughts would greatly appreciated.

  2. #2
    VBAX Mentor
    Joined
    Sep 2019
    Location
    Philippines
    Posts
    416
    Location
    try investing your time on MS Access.

  3. #3
    VBAX Expert
    Joined
    Mar 2008
    Location
    Kent, England
    Posts
    814
    Location
    If you are still going to use Excel for it then attached is a file that may have a few pointers to help
    Attached Files Attached Files
    If things don't change they stay the same
    Quite often there is a picnic problem (problem in chair not in computer)
    "We were not told it was impossible, so we did it."

  4. #4
    Thanks guys for the reply. I have been slowly learning how to code in VBA and I know this is an ambitious project.

    arnelgp- I have looked at MS Access but I have never really messed with it too much. Guess I will look at some tutorial videos on YouTube.

    georgiboy- After looking at the code in that file I can see how it works. I was trying to make the combo box values set to a variable like (X) instead of putting the value into actual formula likes this: sheets(Me.Combobox1.Value)

Posting Permissions

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