RESIZE THE CHECKBOX BLOCK IN THE EXCEL

on

CHECKBOX IN DEVELOPER TAB


So Hello and Whatsupp Guysss,
how long we have't talk together hahahaha
maybe not talking.. its like reading hah..

So this is my post about excel feature..

1st of all.. You guys need a developer tab in excel 1st to use the command button..
oh man maybe i will show you in my another video..

here I want to show you guys how to resize the command button box from the actveXcontrol in the developer tab.

Steps:

    1.     Open your excel.. please we want to use feature in excel right.. so open it. double click on it NOW!!.. (MUAHAHAHHAA)

    2.     Okay so there are the developer tab.. Click it.

    3.     Then you will see that INSERT, now click it

    4.     Then there are many choice you guys have.. whether to take command button, drop down list or a text box..

    5.     Okay now if you take a normal checkbox, you will have a hard time in resize the block. let me give you some example 

when you guys resize it by dragging the edge, it will not make the box bigger it will just make the text box bigger

    6.     You guys need to change the wording where you put the label before putting the actual label.


then here is the label where you guys can take it from the insert in the developer tab


    7.     For example, this label is at C4, you guys know how to read write ( column C, row no 4 ). Change it to Windings

    8.     Then you guys make sure that the developer tab still in design mode, where you guys can put the coding by simply double click the label
now it will look like this, then you paste the coding above in here

    9.    Then now is the hard part, where you need some coding for it to work and it something like the coding below:

            " Private Sub Label1_Click()
                    If Label1.Caption = Chr(254) Then
                        Label1.Caption = Chr(168)
                    Else
                        Label1.Caption = Chr(254)
                    End If
                End Sub "

* need to make sure that all label have the same value, if it label1 then all of the coding need to label as label1

    10.     Then you got your checkbox.. and if you want it bigger you guys just need to delete the current label, then resize the font then just put a new label in the same place as the previous one..




Maybe i need to give you guys a video so it will be more simpler to understand right.. 
nah i wil just put it in the reel first....

see you there.. byeee


Comments

Post a Comment