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
    try investing your time on MS Access.

  3. #3
    Moderator VBAX Master georgiboy's Avatar
    Joined
    Mar 2008
    Location
    Kent, England
    Posts
    1,158
    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
    Click here for a guide on how to add code tags
    Click here for a guide on how to mark a thread as solved

    Excel 365, Version 2401, Build 17231.20084

  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
  •