vba & excel & forms

Good afternoon! I'm still very very new to VBA and user forms in Excel so I'm hoping to get some help. I'd like to create a user form that would allow for the selection of 2 independent defined variables and produce all possible results. Example: I have a remote that can use multiple battery...

Hi, I need to select option "Assigned to anyone" from below code. it looks like drop down list. HTML for it is as below <select class="form-control ng-pristine ng-untouched ng-valid ng-not-empty" ng-model="viewOptions.assignedToMe" ng-options="opt.value as opt.label for opt in...

Hi Everyone, I coded this following in adobe PDF using java script and I would now like to convert it into excel. Could you please help me with trying to convert this following code into VBA? if (event.value == "Distribution") { var cost = Number(this.getField("cost...

Hi everyone, The code I have does what I would like it to do, however, I would like to change how it selects the data. Right now, it copys and paste data based on the location of the cells. Now, I would like to copy and paste the data based on the headers in row 8 of "Activity Tracker -...

This is my first post.. I'm attempting to create a macro to do the following: 1.Input contains Mapping Sheet to Match different Headers Ex: <code>Mapping Sheet +------+------------+------+ |header 1 | header 2 | +------+------------+------+ |sam_name | sam.value | |John_name...

Hi all, Firstly thank you for taking the time to read my post.. My Question: I have an image that I want to put into into excel document and when a user completes a certain cell value corresponding to the part of the image it fills in the specific part of the image with that cell value. For...

Hai Dudes, I would like to select the range of cells in one row which contains some merged cells in between. The macro has to be run for many files with different range of cells. For example File1 has to be select from C5:C10, file2 has to select from C5:C20. There are some cells merged in the...

I am having trouble setting some automation. It works best if I explain I have three types of "Products" these products can be purchased Separately or as a collection. The can be "Completed" at different times. I collect the data as separate projects, but need to see them as a collection also...

I am working on a project for a companies payroll. What I am doing is taking payroll data and using a button to automate and organize the data to enter into our accounting software. I am moving along nicely, but the problem I am seeing is when an employee leaves or are added and their VBA code...