Valli

Home/Valli

About Valli

Excel VBA Developer having around 8 years of experience in using Excel and VBA for automating the daily tasks, reports generation and dashboards preparation. Valli is sharing to helps us automating daily tasks.

Column Name to Column Number

Column Name to Column Number is nothing but converting Excel alphabetic character column name to column number. Most of the time while automating many tasks it may be required. Please find the following details about conversion of column name to column number. You can also say column string to column number. Or get alphabetic character to column number using Excel VBA.

Remove CheckBox on Worksheet or UserForm in Excel

We can remove or delete checkbox on the worksheet or userform using ‘Go To Special’ or ‘Select Objects’ or by turning on Design Mode in Developer tab. when we don’t want to place checkbox control on the worksheet or userform we removes from there. Please find the more details and screenshots for clear understanding about remove checkbox control in the following chapter.

Add CheckBox on Worksheet or UserForm using VBA

We can add CheckBox on Worksheet or UserForm is using VBA with checkbox control and is used to specify or indicate boolean choice. In this section we will see how to add single checkbox or multiple checkboxes on the worksheet or userform using VBA. Please find the more details about add checkbox control using VBA in the following chapter.

By |April 12th, 2015|VBA|2 Comments

Add CheckBox on Worksheet or UserForm in Excel

Add CheckBox on Worksheet or UserForm is using checkbox control and is used to specify or indicate binary choice. In this section we will see how to add single checkbox or multiple checkboxes on the worksheet or userform. Please find more details about add checkbox control in the following chapter.

By |April 12th, 2015|Excel VBA|1 Comment

Related pages


macro recorder excel 2010how to turn on developer tab in excel 2010project management calendar template excelexcel formula not blankvba columnwidthvba queryexcel enable macrohow to create a combobox in excel 2010project charter template wordadvanced macros in excelsample project timeline excelvba ebookformula for vlookup in excel 2007advanced excel vba examplesvba debuggerexcel macro beginnervb exit for loopautofit row height excel 2010multiple if statements excel 2010how to open excel workbookexcel vba range resizegantt chart excel 2003run excel macro on openvba insertvba paste from clipboardreturn vbaexcel vba lastrowsql interview questions and answers for experienced pdfiferror in vlookupexcel combo box vbaexcel 2010 unhide worksheetexplain formula in excelexcel hotkey switch sheetsexcel dashboard widgetsconnect to sql server from excel vbaunhide top rows in excelproject log template excelhow to create a named range in excel 2013working with arrays in exceldata mining interview questions and answershighlight duplicate entries in excelremove a hyperlink in excelvba coding for dummiesdeveloping dashboardshow to convert column to row in excelvba access sqlexcel insert worksheetvba debugvba macro loophow to protect excel from editinghow to use a pivot table in excel 2010nested if function excel 2007how to adjust row height in excelwhat is descending order in excelconstruction cost excel templatevba coding for dummiesms excel templates for project managementexcel vba open files in folderinstr examplesvba save excelfree excel dashboard widgetsexcel formula to highlight duplicatesunlock excel spreadsheet macroexcel row colordml commands in sql serverxlsm to xmlexcel vba data typessheet tab excelwhat is a hlookupexcel hlookup tutorial pdfusing trim in excelexcel programming vbaactivity plan template excelchoose formula in excelvba close excelspider web diagram excelcommands in dbmsvlookup in excel vba with examplesexcel protected workbook forgot password