Results 1 to 1 of 1

Thread: Macro value "Text" linking to input cell value of another sheet

  1. #1

    Macro value "Text" linking to input cell value of another sheet

    Hello
    Based on my previous thread :

    http://www.vbaexpress.com/forum/show...ight=hide+rows

    Is it possible to link the macro value from a cell from another sheet, so the user can choose his own letter to hide/unhide the rows :

    Value "O" to sheet 2 range B2:
     If UCase(Target.Value) = "O" Then 
        Value "C" to sheet 2 range B3:
    ElseIf UCase(Target.Value) = "C" Then 
       'As well for the module : 
       (UCase(cll.Value) = "O" Or UCase(cll.Value) = "C")
    Thanks very much for your help
    Last edited by Aussiebear; 12-14-2024 at 11:35 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •