Show exactly one column based on user input

[mathsbeauty]

There is a drop down list from D to AG in VBA user form. The user selects any column from D to AG in the form. I am looking for a simple VBA code to show exactly one column from D to AG (which user have selected) and hide all columns between D to AG. All other columns (not in between D and AG) remain unaffected.

 

[hajiali]

What is the Code to your VBA userform?

 

[mathsbeauty]

What is the Code to your VBA userform?

The user form is a little complicated to post here. Let's assume that user has selected column "AC"

 

[Peter_SSs]

Let's assume that user has selected column "AC"

Try

Sub ShowOneCol()
  Application.ScreenUpdating = False
  Columns("D:AG").Hidden = True
  Columns("AC").Hidden = False
  Application.ScreenUpdating = True
End Sub

 

[mathsbeauty]

Try

Sub ShowOneCol()
  Application.ScreenUpdating = False
  Columns("D:AG").Hidden = True
  Columns("AC").Hidden = False
  Application.ScreenUpdating = True
End Sub

Thanks. I was looking for such a simple code.

 

[hajiali]

try this for Userform Dropdown. this will require user use the dropdown click on button

Private Sub CommandButton1_Click()
Dim Clm As String
Clm = ComboBox1.Value
ActiveSheet.Range("D:AC").EntireColumn.Hidden = True
ActiveSheet.Cells(, Clm).EntireColumn.Hidden = False
Unload Me
End Sub

 

[Peter_SSs]

Thanks. I was looking for such a simple code.

You're welcome. Thanks for the follow-up.

 

[hajiali]

I'm confused did you want the user to select from the dropdown or just always Hide the Column "AC"? if I'm not mistaken the Code posted by Peter post 4 will always hide Column "AC"

 

[mathsbeauty]

I'm confused did you want the user to select from the dropdown or just always Hide the Column "AC"? if I'm not mistaken the Code posted by Peter post 4 will always hide Column "AC"

 

[mathsbeauty]

Your code provides a complete solution. I just wanted to have an idea which I got from Peter's answer.