Windows 10: VBA: Shortcut does not unhide rows. F5 from the VBA screen does. Why?

Discus and support VBA: Shortcut does not unhide rows. F5 from the VBA screen does. Why? in Windows 10 Software and Apps to solve the problem; Sub Upper_Left_Borrower'Go to cell A2 Application.Goto Range"A2", TrueCall Unhide_RowsEnd SubSub Unhide_Rows'Unhide Rows... Discussion in 'Windows 10 Software and Apps' started by Mark Nadel, Aug 6, 2023.

  1. VBA: Shortcut does not unhide rows. F5 from the VBA screen does. Why?


    Sub Upper_Left_Borrower'Go to cell A2 Application.Goto Range"A2", TrueCall Unhide_RowsEnd SubSub Unhide_Rows'Unhide Rows ThisWorkbook.ActiveSheet.Select 'Range"2:301".Select Rows"2:301".EntireRow.Hidden = FalseEnd Sub

    :)
     
    Mark Nadel, Aug 6, 2023
    #1

  2. VBA textbox Powerpoint

    In slide show mode, the cursor is in vba textbox1, when the tab key is pressed the cursor moves to vba textbox2. The vba textbox1 does not disappear.
     
    Tania1234zz, Aug 6, 2023
    #2
  3. Try3 Win User
    VBA missing

    VBA is part of MS Office and continues to be supported within currently-supported MS Office versions.

    If another application requires VBA then it ought to provide it. I can only suggest that you ask Corel how you were supposed to get VBA - perhaps it was an installation option that you did not notice.

    Note that VBA is not the same thing as Visual basic. VBA is an Office component, Visual basic is a programming application.

    Denis
     
    Try3, Aug 6, 2023
    #3
  4. BrooksyX Win User

    VBA: Shortcut does not unhide rows. F5 from the VBA screen does. Why?

    Help with Excel VBA Problem?

    Can someone help me code the following VBA problem:

    "Assume you have a mailing list file. This file is currently the active workbook, and the active worksheet of this book has full name in coloumn starting in cell A1, with the last name last and everything in uppercase letters (such as STEPHEN E. LEE). Write a sub that counts the number of names in the list with last name LEE and then displays the count in a MsgBox. Not that there might be last names such as KLEE, which should not be counted."

    Thanks!
     
    BrooksyX, Aug 6, 2023
    #4
Thema:

VBA: Shortcut does not unhide rows. F5 from the VBA screen does. Why?

Loading...
  1. VBA: Shortcut does not unhide rows. F5 from the VBA screen does. Why? - Similar Threads - VBA Shortcut does

  2. VBA: Shortcut does not unhide rows. F5 from the VBA screen does. Why?

    in Windows 10 Gaming
    VBA: Shortcut does not unhide rows. F5 from the VBA screen does. Why?: Sub Upper_Left_Borrower'Go to cell A2 Application.Goto Range"A2", TrueCall Unhide_RowsEnd SubSub Unhide_Rows'Unhide Rows ThisWorkbook.ActiveSheet.Select 'Range"2:301".Select Rows"2:301".EntireRow.Hidden = FalseEnd Sub...
  3. 123456 vba

    in Windows 10 Gaming
    123456 vba: There are some more optionsSet myDataRng = Worksheets"sheet1".Range"A1:A10" & CellsRows.Count, "B".EndxlUp.RowDim str As String ' Run a loop. For Each cell In myDataRng If Trimcell.Offset2, 0.Value <> "" Then If Trimstr = "" Then str = cell.Offset2, 0.Value Else str = str &...
  4. 123456 vba

    in Windows 10 Software and Apps
    123456 vba: There are some more optionsSet myDataRng = Worksheets"sheet1".Range"A1:A10" & CellsRows.Count, "B".EndxlUp.RowDim str As String ' Run a loop. For Each cell In myDataRng If Trimcell.Offset2, 0.Value <> "" Then If Trimstr = "" Then str = cell.Offset2, 0.Value Else str = str &...
  5. 123456 vba

    in Windows 10 Software and Apps
    123456 vba: Tried this one as wellSubDynamicWebPage' here I define elemnts for the loopDim sht As WorksheetSet sht = ThisWorkbook.Sheets"data"Dim LastRow As LongDim i As LongLastRow = sht.Cellssht.Rows.Count, "A".EndxlUp.Row' here I define Internet ExplorerDim IE As ObjectDim Doc As...
  6. 123456 vba

    in Windows 10 Gaming
    123456 vba: Set oHDoc =oIE.DocumentOption ExplicitConst sSiteName = "https://www.test.com/"Private Sub CommandButton1_Click Dim oIE As Object Dim oHDoc As HTMLDocument Set oIE = CreateObject"InternetExplorer.Application" ' Open Internet Explorer Browser and keep it visible. With oIE...
  7. 123456 vba

    in Windows 10 Software and Apps
    123456 vba: Set oHDoc =oIE.DocumentOption ExplicitConst sSiteName = "https://www.test.com/"Private Sub CommandButton1_Click Dim oIE As Object Dim oHDoc As HTMLDocument Set oIE = CreateObject"InternetExplorer.Application" ' Open Internet Explorer Browser and keep it visible. With oIE...
  8. Excel, VBA: What does or what is BeforeDragOver?

    in Windows 10 Software and Apps
    Excel, VBA: What does or what is BeforeDragOver?: I can still imagine something under top or height. [ATTACH] Excel, VBA: Was macht oder was ist BeforeDragOver?
  9. VBA missing

    in Windows 10 Support
    VBA missing: Not sure where to put this... I've been trying to resolve some 'glitches' with a legacy version of CorelDraw (X4). Someone on the CorelDraw forum suggested a macro. Which entails using "Script manager (in Corel), which in turns wants Visual Basic for Applications. After my...
  10. VBA code

    in Windows 10 Customization
    VBA code: I have been working on program in VBA code. I have been able to access with alt F11. Now I am unable to view my code. https://answers.microsoft.com/en-us/windows/forum/windows_10-other_settings/vba-code/e9ef2778-957d-4354-8346-458793521d8b