Creating the Chart on a VBA user form is quite interesting. We have created 4 KPI Charts – Battery Chart, Speedometer Chart, Moving Man Chart and Progress Circle Chart on a User form which is fully dynamic. KPI value is connected with a Textbox. As soon as the text box value will be changed chart will show the updated number. We have also given the Change chart type drop-down. KPI
In this article you will learn how to use a web browser in the user form. You can search anything or open a website using the text box. [caption id="attachment_7077" align="aligncenter" width="1310"] Web Browser in User form[/caption] Below are the steps to create the web browser in the user form- Go to the Visual basic editor (Press Alt+F11) Open the Toolbox. [caption id="attachment_7069" align="aligncenter" width="604"] Open the Toolbox[/caption]
While creating the data entry form in VBA, we need to put several validations. One of them is dependent drop-down. In this article you will learn how to create multilevel dependent drop-down in VBA user form. To create the dependent drop-down list, we have to create the data in Excel sheet as given in below image. [caption id="attachment_7034" align="aligncenter" width="773"] Data for dependent drop-down[/caption] Below is the VBA
While create the Data Entry form in VBA, We need to put some validation in text boxes and combo boxes. In this article you will how we can put the validation for Mobile Number entry. Below is the user form wherein we have created a text box to input the Mobile number. [caption id="attachment_6942" align="aligncenter" width="364"] User form[/caption] After submitting, the mobile number will be added to the worksheet. [caption
Here we have created a beautiful and dynamic Project Plan (Gantt chart) in Excel. We have given a drop-down to change the weekly and daily view. There are 3 type of status has been given Pending, Completed and In-Progress. We have used VBA to change the View daily to weekly and visa-versa. This is password protect worksheet. The password is “1234” Below is the Weekly View- [caption id="attachment_4053" align="aligncenter" width="1183"]
In this article you will learn how we can use an excel range as a filter criteria and paste the filtered data on another worksheet. For example, we have below data in “Data” worksheet. [caption id="attachment_4042" align="aligncenter" width="831"] Data to be filtered[/caption] We have below given Employee list whose data has to be filtered and copied on “Output” worksheet. Here we have created a macro to get the desired output.
We often need the count of sub-strings from out text available in Excel. For example we have comma separated ticket number in a cell and we have to count how many ticket numbers are available in the cell. We have semicolon “;” separated email ids the how can get the count of email ids. [caption id="attachment_4035" align="aligncenter" width="688"] User Defined Function[/caption] Here we have given the solution of this
In this article you will learn how we can split our data into multiple workbooks. Every workbook will be saved in the given folder path. This macro can be used when you have a long list of your data and you have to make different files with specific data. Here in this example we have taken Employee wise performance data and we have to split our data for each supervisor.
In this article you will learn how to create a Personal Macro in MS Excel. I have created this personal macro to format the data quickly.Any macros that is stored in your personal workbook become available whenever new excel opened on that same computer for the same user. To create a personal macro first of all we have enable the Personal.xlsb in Visual Basic Editor. Below are the steps to
In this article you will learn how to send an Outlook Email with mail body snapshot like Excel tables, Charts or images by using VBA. We will use "Mail Envelope" method to sending the email. This method is quite easy and small. We have to create our data on a worksheet in email format and It will send the entire worksheet or selected range on outlook mail body. As in the