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


database dml ddlexcel ribbon vbaexcel useful macrosvba excel beginnershow to concatenate in vbavba readlineexcel mergerunprotect sheetcopy range vbavba excel developervlookup usageinput output worksheethow do you delete duplicates in excelexample of ddlexcel count if functionopen file dialog vbaexcel formula based on color of cellactivecell selectsort excel macroexcel sendmailcountifs formula in excelhow to dedupe in excelvba ucaseif statements excel 2010break loop in vbahelpful excel macroshow to unhide columns in excel 2010excel vba open files in folderadodb connection openscreenupdating vbahow to use if formula in excel 2007learn vba from scratchexcel 2007 macrosadvanced vba excel examplesexcel 2003 autosavesql query from excelremove duplicate cells in excelsql pivot table tutorialexcel vba populate comboboxhow to use vlookup in excel 2010 step by stephow to change row to column in exceltutorial macro excelsyntax of vlookupvba excel save workbookvba oledbexcel remove duplicate linesvba sheet1project gantt chart excel templatesort selected cells by last name in ascending ordervba open csvremove hyperlink in excelvb clear listboxbreak loop in vbaenable macro exceldml statements in sqlvba as doublevba excel pastespecialms access vba update querymicrosoft excel check boxvba variable in rangedelete duplicate rowsexample for vlookupcount if excel functionexcel hide columns shortcutexcel merge rowsexcel shortcut edit formulaconnect to sql server from excel vbaoops interview questions pdffix vbajob cost sheet templateexcel dashboard templates freevba excel sql queryhow can i hide columns in excelvba globalchart templates in excelhow to merge two columns in excel 2007excel checkbox macroapplication function vba