+ Reply to Thread
Results 1 to 2 of 2

Userform Search Button and number manipulation.

  1. #1
    Registered User
    Join Date
    02-13-2015
    Location
    Newcastle upon Tyne england
    MS-Off Ver
    Excel app
    Posts
    8

    Userform Search Button and number manipulation.

    Hi Guys. First question is i've built my first userform which will enter my data for me. After time i may need to refer to a specific date so looking to add a search button that can run a search based on any of the information in the textboxes on my userform and take me to the relevant row.

    Also my project is a money dividing project. Basically i enter the information off of my wageslip (userform1) then the information is sent to several sheets, divided up according to my wishes, data recorded and the end sheet basically tells me how much and where to put my money.
    Hope that makes sense.

    This is my first time using excel so am completely new to coding and how to construct it.
    So far i've managed to build and code my userform for my first sheet and the only thing missing from it is a search button.

    Any help would be appreciated and of course if anyone could point me in the direction of a good excel education page so i can learn this coding stuff for myself i would appreciate it. Thank you for you time.

  2. #2
    Registered User
    Join Date
    02-13-2015
    Location
    Newcastle upon Tyne england
    MS-Off Ver
    Excel app
    Posts
    8

    Re: Userform Search Button and number manipulation.

    Need to be a little more specific with this i think.
    I have created a userform to enter the data from my payslip onto the worksheet. So textboxes for hours worked, tax, insurance etc etc.
    I want to put a search command button on the userform and i want to be able to enter the data i'm looking for into the pre-existing text boxes and when i hit search, i want it to take me to that row on the form.
    So if i'm looking for a specific date i can enter the date in the textbox hit search and be taken to that date row on the worksheet.
    Unfortunately i know nothing about code and only know to copy what i see somewhere else.
    Any help will be appreciated. busy reading through some excel 2003 tutorials to see if i can find the solution there.

    Thanks in advance guys.

+ 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. [SOLVED] userform search button remove search only when i type
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-08-2014, 02:32 AM
  2. Save Button and Search On Userform faults
    By flyinghigher2011 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-22-2013, 12:49 PM
  3. [SOLVED] Search button on an USERFORM
    By alopecito in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-25-2012, 09:34 AM
  4. [SOLVED] Search button in userform
    By Ray316 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-07-2011, 09:10 AM
  5. Search Button On Userform
    By markrennolds in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-03-2010, 04: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