+ Reply to Thread
Results 1 to 2 of 2

Need helps with a few Macros

  1. #1
    Registered User
    Join Date
    03-17-2006
    Posts
    16

    Need helps with a few Macros

    Obi-Wan Kenobi (without the force)

    I have several questions and would greatly appreciate if anyone could help me on answering some or all of my queries. I am building a customer list and need help on the following.

    1) Is there a way to time set worksheets, e.g. if worksheet1 is opened then after about 10 seconds sheet2 will open automatically and then sheet3 and so forth?

    2) Is there a way to get a box to open when it is hovered above and Icon/image, to advise the user of the function of that icon/image? The image is NOT sitting in a cell but is already in another box.

    3) When a search for a customer record is done lets say in sheet1 and the record is not found how do I get a box to open which give the user the option to create and NEW record or press cancel? If pressed YES a form will open in worksheet2 for completion?

    4) And finally for today and this relates to Q3. I have the following code (See Below). It allows for a search of a record to take place when a word it typed in to Cell A1 and to further filter the list the user can type into Cell G1, This takes place all on ONE Worksheet.

    I like this search tool but I want to have the search Fields (A1 and G1) in worksheet1 and the customer list in Sheet3. I also want more search field options, e.g. Location, ID No. Name1, Name2, ***,

    This is the "Criteria" range which sits in cell J2

    =AND(OR($G$1="",D4=$G$1),ISNUMBER(SEARCH($A$1,E4)))

    The workbook is called DATA and this is the code.

    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Count > 1 Then Exit Sub
    If Target.Address = "$A$1" Or _
    Target.Address = "$G$1" Then
    Range("Database").AdvancedFilter _
    Action:=xlFilterInPlace, _
    CriteriaRange:=Range("Criteria"), Unique:=False
    End If
    End Sub

  2. #2
    Carim
    Guest

    Re: Need helps with a few Macros

    One question per post would make life easier to everyone ...

    Carim


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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