+ Reply to Thread
Results 1 to 4 of 4

Excel Sheet Management With Userform

  1. #1
    Registered User
    Join Date
    12-16-2019
    Location
    Alaska
    MS-Off Ver
    office 2010
    Posts
    13

    Excel Sheet Management With Userform

    Name:  sheet_add_delete.jpg
Views: 3693
Size:  118.9 KB

    I created a userform and added a listbox, combobox, buttons, textbox control into the userform.

    With the Userform, a new sheet can be added to the workbook, the sheet can be deleted, and the pages of the workbook can be navigated.
    Attached Files Attached Files

  2. #2
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: Excel Sheet Management With Userform

    You can do all of that without an ugly userform, so what is the point of it?

  3. #3
    Registered User
    Join Date
    12-16-2019
    Location
    Alaska
    MS-Off Ver
    office 2010
    Posts
    13

    Re: Excel Sheet Management With Userform

    The important thing here is to do the operations with Vba codes.
    Wouldn't it be easy with combobox to navigate between pages in multi-sheet workbooks?

  4. #4
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: Excel Sheet Management With Userform

    I don't fin it difficult, so see no reason to invent a VBA solution for it. Just because you can doesn't mean you should,

+ 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. Project Management Excel Sheet - Auto Fill Date Fields
    By djc123 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-29-2019, 08:35 AM
  2. Excel Sheet for team management
    By Zenden in forum Excel General
    Replies: 1
    Last Post: 01-13-2018, 11:35 PM
  3. [SOLVED] data management system using userform
    By bqheng in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 07-29-2017, 02:23 AM
  4. Case Management Excel Sheet
    By Markel in forum Excel General
    Replies: 2
    Last Post: 06-14-2012, 05:51 AM
  5. Replies: 0
    Last Post: 07-10-2006, 03:29 AM

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