+ Reply to Thread
Results 1 to 9 of 9

Excel VBA creating a backwards and forward button on a already created form.

  1. 07-19-2019, 11:23 PM #1
    Sparky5097
    Sparky5097 is offline
    Registered User
    Join Date
    07-19-2019
    Location
    Brisbane, Australia
    MS-Off Ver
    2016
    Posts
    3

    Excel VBA creating a backwards and forward button on a already created form.

    Hi All

    Im new to the group and VBA code writing only started this week!

    I'm also new to a lot of th terms that get bantied around, so please be patient.

    I have created a form in Excel with a potentially large data sheet.

    I have a form and data sheet in a excel file, the data has 13 coloums of data I require to record for each the tasks.

    I have creted the form on the excel sheet "Form" and have linked all the coloums and data required.

    What I need on the form is a backwards and fordward buttons to move through the data while viewing the form.

    I have created this form from something similar on youtube and I got it to work for my data.

    Unfortunately it didn't have a back and forward button and the samples I've seen so far don't fit, and as my understanding at this time is limited I'm finding it difficult to create these 2 buttons.

    If you need the excel file I can attach

    Please see below a copy of my code so far.

    If anyone can help please let me know.

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Last edited by Pepe Le Mokko; 07-20-2019 at 03:32 AM.
    Reply With QuoteRegister To Reply
  2. 07-20-2019, 02:36 AM #2
    AlphaFrog
    AlphaFrog is offline
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Excel VBA creating a backwards and forward button on a already created form.

    Hi and welcome to the forum, Sparky.

    First things first; It's a forum rule to surround all posted code with CODE tags. See my signature block below. It makes reading your post much easier. Edit you previous post now and add the tags. Nothing else will happen until you do that first.

    Do attach an example file with desensitized data. No one wants to recreate your userform or guess at you data structure.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.
    Reply With QuoteRegister To Reply
  3. 07-20-2019, 03:10 AM #3
    Sparky5097
    Sparky5097 is offline
    Registered User
    Join Date
    07-19-2019
    Location
    Brisbane, Australia
    MS-Off Ver
    2016
    Posts
    3

    Re: Excel VBA creating a backwards and forward button on a already created form.

    Hi AlphaFrog

    Thanks for the welcome and advice. I've copied it again below.

    PS can you tell me how to attach a simple file, the attach button doesn't seem to work as expected.

    Thanks
    Last edited by Pepe Le Mokko; 07-20-2019 at 03:33 AM. Reason: Removed code
    Reply With QuoteRegister To Reply
  4. 07-20-2019, 03:29 AM #4
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Excel VBA creating a backwards and forward button on a already created form.

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Reply With QuoteRegister To Reply
  5. 07-20-2019, 03:34 AM #5
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Excel VBA creating a backwards and forward button on a already created form.

    I removed the code from your last post and added the tags in your first post , to unclutter the thread.
    You can always edit an older post ( within a day or two ) to make amendments
    Reply With QuoteRegister To Reply
  6. 07-20-2019, 03:35 AM #6
    AlphaFrog
    AlphaFrog is offline
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Excel VBA creating a backwards and forward button on a already created form.

    A Forward and Back button is just a row counter. Have a label on the userform that indicates what row you are looking at. Have the forward\back buttons increase or decrease the row number and repopulate the userform with data from the indicated row. Does that help?
    Last edited by AlphaFrog; 07-20-2019 at 03:37 AM.
    Reply With QuoteRegister To Reply
  7. 07-21-2019, 06:56 PM #7
    aubalibowrock
    aubalibowrock is offline
    Registered User
    Join Date
    07-21-2019
    Location
    turkey
    MS-Off Ver
    2017
    Posts
    1

    Re: Excel VBA creating a backwards and forward button on a already created form.

    Hello

    i am also new in this forum have some similar problem (not exactly) but..
    like i want to navigate in a smart art hierarchy graph by macro buttons and want to add shapes below and after or promote demote
    struggling for this about a week i am about to give up if someone just can help will be appreciated

    thanks
    Reply With QuoteRegister To Reply
  8. 07-22-2019, 03:21 AM #8
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Excel VBA creating a backwards and forward button on a already created form.

    @AUBALIBOWROCK

    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
    Reply With QuoteRegister To Reply
  9. 07-24-2019, 07:57 PM #9
    Sparky5097
    Sparky5097 is offline
    Registered User
    Join Date
    07-19-2019
    Location
    Brisbane, Australia
    MS-Off Ver
    2016
    Posts
    3

    Re: Excel VBA creating a backwards and forward button on a already created form.

    Hi All

    Thanks for all your comments and suggestions, unfortunately I need to train myself with a bit more VBA terminology and functionality before I can accomplish this task. So thanks you for your help I will follow this up and comment once I've done some more training. Thanks again!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Reset Button to reset values to default in Drop List (created in Form Control)
    By saguilera in forum Office 365
    Replies: 1
    Last Post: 05-18-2019, 10:31 AM
  2. Moving shapes forward and backwards in Excel Pro 2016
    By brianpatrickjackson in forum Excel General
    Replies: 2
    Last Post: 08-22-2017, 12:57 AM
  3. Creating a Button with VBA that can delete itself + the Row it's created on
    By ALoelke in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-15-2015, 08:37 PM
  4. Add a back and forward button in user form
    By Ajaf123 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-26-2015, 10:18 AM
  5. Creating an Update Button within Excel worksheet (non-form)
    By howieG in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-14-2012, 05:48 PM
  6. Page forward goes backwards
    By apk in forum Excel General
    Replies: 0
    Last Post: 03-23-2006, 11:25 AM
  7. I created a form on excel. want to edit the form without printing
    By Oz in forum Excel General
    Replies: 1
    Last Post: 09-01-2005, 04:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1