Variable input into F30, to point to required macro to hide rows.

[BeeJayII]

Creating a geneology form. Cell F30 specifies how many children in family. This then to point to which part of the macro to operate.
I hope the following shows requirement clearly enough.

Option Explicit
Sub CHILDREN_HIDE()
With Application
.ScreenUpdating = False
.EnableEvents = False
.DisplayAlerts = False
End With

ActiveSheet.Select
' Process to work on potential of 50 - 60 sheets in ONE workbook.
' EACH SHEET would require input into cell F30 - but not affect any other sheet.

' Input # of Children in Cell F30: '(Data Validation set to restrict from 0 thru 12)

' # of childred indicated on F30 is 12:
' Unhide all "children selection" sections
' All input sections are available - Nothing further required.

' If F30 = 12 then
Range(32, 114).Select.Hidden = False 'End process

' # of childred indicated on F30 is 11:
' If F30 = 11 then
Range(109, 114).Select.Hidden = True ' All but 12th child section showing

' Childred: 10
' If F30 = 10 then
Range(102, 114).Select.Hidden = True ' All but 11th & 12th child section showing

' Childred: 9
' If F30 = 9 then
Range(95, 114).Select.Hidden = True ' ETC.....................

Range("A1").Select

With Application
.EnableEvents = True
.ScreenUpdating = True
.DisplayAlerts = True
End With

End Sub

I can't figure out how to set up the Target Value Change (which I assume is required)?
Nor how to have the correct part of the macros to be referenced/selected.

[davesexcel]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)