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


microsoft word project management templateexcel in cell chartvb scripting interview questions and answers pdfremove empty rows in excelms access ddlhow to delete hidden rows in excelexcel macro vba tutorialexit sub vbaexcel macros templatesstacked clustered chart excel 2013examples of hlookupprograming with excelrange cells vba excelfrequently asked sql queries in interviews with answersdelete empty cells in excelsas coding for beginnersproject charter powerpointlookup in ms excelvba declare global variablehow to understand excel formulaswhat does vlookup mean in excelmacros in excel 2007 tutorial pdfautofit row height not workingusing ifs in excelhow to create a sales dashboard in excellearn advance exceldelete duplicates in excel 2003unlock workbook excelremoving duplicate in exceldml meaningvba open txt filemacro to refresh pivot table3d pie chart excelopen file with vbaexcel pivot table shortcut keyunlocking excel spreadsheetadvanced pivot table in excel 2007vba close applicationhide macros in excellistbox vba accessexcel copy workbookhlookup in excel 2010vba excel sort columnworkbook vbalearning vba for excelvba writershort keys of excel 2007hyperlinks in excelvlookup leftinstr function in vbaconcatenate excelsimple macro in excelhow do i merge cells in excelexcel change columns to rowsautofilter in vbacheck marks in excelblank rowhow to learn excel vba programmingplot chart excelhow to delete duplicates in excelexcel vba controlsmacro to combine worksheetsopendatabase vbacode in vbamultiple if then statements in excelhow to sort numbers in excel in ascending orderhow do i unhide columns in excelexcel macro rangehow to unlock excel workbookprotect workbook with password