navigation

  1. G

    Hyperlink that links to a cell relative to the sheet the hyperlink is located in

    Hi, I'm creating an excel sheet for a friend who is even less well versed in excel than I am and I'm having trouble making a hyperlink that just points to a cell, no matter what sheet that the hyperlink is in. Here's an example: I have a workbook with one sheet in it, Sheet1. In cell A1 of...
  2. T

    How to change code to and

    Private Sub Command43_Click() 'Admin Button Bring back nav and other views that are hidden If Text9.Value = "tam.badal" Then 'UnHide the hidden objects in the navigation pane Application.SetOption "Show Hidden Objects", True 'UnLock navigation pane...
  3. gheyman

    Access: Keep Navigation pane closed

    Is there a way to keep the navigation pane closed or keep users from accessing it without proper permissions?
  4. M

    Using a Navigation Form as a subform?

    Hi, I am trying to figure out if there is a simple way to use the Navigation Form option as a subform. I have 6 tables and corresponding forms (and 4 look up tables). My top level table/form identifies a person with two tables branched from there, with one of those tables having 3 more...
  5. J

    Excel Power Query Automate Import of File Navigation

    Good morning; I receive a few text files that needs to be imported and parsed. I wanted to automate this process but my company does not allow us to use VB. Is there a way to automate this process, especially the file navigation, using power query (and not VB)? Thanks
  6. B

    Dropdown navigation menu

    I am looking to create a drop down navigation menu in Excel, and found this Youtube video that is very close to doing what I want it to do. The only thing that I want to change from the solution in this video is that it doesn't require a Go button. I want the user to simply be able to choose...
  7. W

    Navigate to the most recent worksheet

    I'm working with a workbook which has got 11 worksheets. I have frequently switch between worksheets. Mostly I work between different pairs of worksheets. If I use the mouse, sometimes I have to scroll left or right to find the worksheet that I to switch to. I was hoping that there would be...
  8. B

    subform and navigation control, how to reference correctly?

    I am trying to solve how my forms and subforms should work with a navigation control I have my mainform called Personal_Form In this mainform i have a navigation control. One of the links in my navigation control is to a form called AnstallningData_Form AnstallningData_Form is based on a...
  9. D

    Excel VBA - Capuring Tab navigation

    Is there a way, with VBA, to capture the tab someone is navigating to? I would like to capture the navigation request, run some code based on the tab requested, then navigate to the tab. Thanks in advance for any help. -Dan
  10. K

    re photos

    hello friends am on a small school, project and i wish one to help me with a code which can import photos to one page and display 1 image per cell value on the next page. on the next page i used navigation buttons and i wish to use those to scroll through the images on sheet 1 one by one. thank you
  11. J

    referencing a control on a subform list in a navigation form

    hi All, I have a navigation for 01 Main On the navigation form, I have a subform FrmSocialGraph On the FrmSocialGraph I have a Subform FrmSGUsgage - which has a list box on it. From the list box I need to pass a value to the textbox on FrmSOcialGraph. My code looks as follows: Private...
  12. P

    VBA to navigate website with dropdown menu

    I am trying to get to the login screen and automatically enter the username and password and clicking on Enter. I have been successful on other sites but the following site has a "Login" button that functions as a dropdown menu. I can't figure out how to navigate past the dropdown menu to get...
  13. D

    MultiPage UserForm TextBox Event+Navigation Glitch

    I have a 4 page MultiPage control in a UserForm. On the 2nd page, I have a group of 2 option buttons followed by a series of TextBoxes in which I need to enter dates. To manage the TextBoxes, I have a separate UserForm, named CalendarForm, that serves as a date picker. After as much...
  14. V

    Get cell value from A3 in 30 different worksheets

    Trying to find a way to look at 30 worksheets and if sheetname matches column b in navigation sheet I need text in A3 from sheets to be entered in column b in navigation sheet. Any ideas.
  15. M

    Scrolling Right and Left in Excel 2013 365

    Howdy! In excel 2007 and earlier excel had the ability to scroll right and left by simply 'nudging' the wheel of the mouse right or left [Yes I am aware you can also push the scroll wheel down and move the mouse in any direction, I don't like this method]. I'm currently using my corporate...
  16. B

    Macro that creates a shape on each sheet

    Hi Guys, I'm currently working on a macro that creates a shape on each visible sheet. And then I want to assign a Macro to those shapes. This is what i have so far Sub AddNavigationPage() Dim ws1 As Worksheet, ws As Worksheet With ThisWorkbook .Sheets.Add(Before:=.Sheets(1)).Name =...
  17. B

    Create macro that assigns value in a cell to Shape

    Hi Guys! I'm having some trouble assigning a name to a shape via a macro. Right now my macro is creating a list of visible sheets, and then creating an equal amount of shapes onto the worksheet. I would like my macro to assign the shapes created with the value that is in the list created...
  18. J

    Navigating between workbooks in 2013

    Have just recently upgraded from 2010 to 2013. I notice with 2 books open that when I attempt to click within the foreground workbook that my cursor lands on a background workbook. Repeatedly. I generally Alt-tab between to navigate. The only way to make contact with the correct book is to...
  19. J

    Go to specific access form record using multiple search criteria

    Hi, I want to go to a specific record in a form if I type in a 'Date' and filter two combo boxes with the 'Team name' and 'Code'. Each record in the form has the 'Date' in a text box and the 'Team name' and 'Code' in separate combo boxes. I want to view the search result in form view and...
  20. S

    Previous Worksheet Navigation

    Hello, I asked this question in 2012 and didn't get a solution so I'm hoping that somebody will be able to help me 4 years later. I would like to have a "PREVIOUS" navigation button in a workbook that goes back to the previously activated worksheet, which may or may not be physically the...

Some videos you may like

This Week's Hot Topics

Top