PDA

View Full Version : Macro value "Text" linking to input cell value of another sheet



guatelize
03-26-2012, 01:01 AM
Hello:help
Based on my previous thread :

http://www.vbaexpress.com/forum/showthread.php?t=41475&highlight=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