Home > Excel Tutorial > Hide & Show Columns with Combobox

Hide & Show Columns with Combobox

You can hide and show columns (months) with combobox.So that you can examine large pages more comfortable.

The comboBox opens automatically while the mouse over it.It’s code :

Private Sub ComboBox1_MouseDown(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)    

Me.ComboBox1.DropDown

End Sub

Download Template

  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: