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


vba pivot tablevba hide columnexcel vba form controlsexcel duplicate sheetfind duplicate row in excelmacro to close workbookvba code timerconsolidate excel filesvba sql connectionhow do you merge cells on excelwhat is vlookup functionvba excel open text filesample vbscript programsremove duplicates from list excelif functions in excel 2010ms project templates 2010clear comboboxvba yes no boxvba deleteexcel interview questions and answers pdfrecording macros in excel 2007vba current cellin excel how can i find duplicatesexcel vba row heightchart types in excel 2010excel 2010 stacked bar chartit fresher interview questions and answersexcel advanced filter formulawhat is the match function in excelddl operations in sql servervba output to text fileworkbooks closevlookup leftvba change font sizevba string to integershort keys of excel 2007steps in creating a chart in excelvba programming in excelhow to unhide column a in exceldml examplesexcel macro open excel fileunhide cellhow to delete a cell in excelexcel vba import csvto merge cells in excelsql excel vbatracking sheet excel templateconditional statements worksheetshow to write insert query in excelvbscript filesystemobject methodsexcel vlookup example downloadnested if and statements excelvertical lookup excel 2007formulas in excel 2007 with examplesend loop vbavba loop untilexcel vba activeworkbook saveasvba save excel fileexcel connect to sql servervba macro functionexcel vba activesheetadodb connection string oraclemerge multiple worksheets into onevba datevalueranges in vbavlookup na errorhow to build an excel macroexcel vba tipsunlock protected excel spreadsheetcell shading in excelfor loops in excelexcel vba cell offsethow to run a macro in excel 2007vba call a macrovba protect workbook with passworddcl data control languageaccess vba queryexcel programing tutorialvba create userform