assign

Hi All, I've developed a spreadsheet which is an audit document however some sections are not applicable to some sites. My issue is that because the questions are not applicable, I don't assign a score which results in a percentage score of 0%. This has a negative impact on their overall score...

I'm searching for a macro that would go through headers (A1, B1, C1 ... P1), search for a text ("AAA" and "BBB") and then assign a variable to the column that contains the text (Set columnA=ColumnContaningTextAAAinHeaders and columnB=ColumnContaningTextBBBinHeaders) I'm guessing I would first...

I want to assign a value segment to a range of values I have, the value segments and criteria are shown below. Would filter and manually adding these be the best way to do this? Or is there a formula that would work better? <colgroup><col><col></colgroup><tbody> Value Segment Criteria 500...

Is it possible to assign the up/down & left/right keyboard key to a userform spin button so that I don't have to use a mouse to scroll up/down through my list?

Good day everyone. Where has the year gone! I've been ripping my code to pieces trying to write this one simple line; however, I can't get my head around it. I need to pull a value already populated in ComboBox1 from Sheet-B then assign that value to a variable on Sheet-A. I just can't...

Hi everyone. want to assign serial number in column A like 1,1,2,2,3,3 and like using following vba code but asssign serial number like 1,2,3, and like Sub FillSerialNumbers() With Range("A3:A" & Range("B" & Rows.Count).End(xlUp).Row) .Cells(1, 1).Value = 1 .DataSeries...

Hi, I have a Form Button (not Command button) on a sheet and want to call a global function. Something like this: MyFile.xlsm!MyFunction(Sheet.Name) How do I do this using the Assign Macro dialog box? Thank you for your help StaffsLebowski

Hi I have the following 2 columns. I want to assign the order no. for each client using VBA as below. There are several worksheets in the workbook. But the code doesn't work. Please help. <colgroup><col><col></colgroup><tbody> <colgroup><col><col></colgroup><tbody> Order Client 1 123 2...

Hi Folks, I'm setting up a spread sheet that will ultimately have up to 10,000 records in it. I need to assign a unique ID to each row. I don't want to use a formula with "+1" as I will have to delete rows and add rows from time to time and I need the ID to remain constant(unique) to that row...

Really, I just can't believe that I constantly get the "Can't assign to array" error message... :( I can read an XML file easily and assign the node values to a collection but the same is not true for an array. I don't know why, I guess I need to read more about Collection vs Array differences...

Hello I know I can do this Set myworkbook = Application.Workbooks.Open("c:\abc.xlsx") So I want to assign abc to myworkbook without opening the file. Is that possible? Thank you so much.

Good Afternoon, I was hoping that the forum may be able to help me with amultilevel “IF” function. I do not think it would be very complicated but I can’tquite nail down the formula. What I would like to do is have the formula display thefollowing: If cellA1 is greater than $30,000 assign...

Normally, If I create a macro/sub and click the macros button on the developer ribbon I see a list of available macros that are formated as one word. For example, I have macros named: Refresh, GetStats, PositionFill etc.. I can easily assign a shortcut ket to these or call them in a sub...

Hi, How do i write a code to find multiple words (for example: AM and PM) in a column and assign a number "1" at the next 2 columns. I'm able to find "AM" and assign 1 next to it but i don't know how to add PM into the code and move the number "1" to the next column. I would be so grateful...

I am trying to assign a button to a new macro. I tried to insert the macro into the workbook but it ended up in the project every time. I am unable to assign the button. I would appreciate it if anyone has a link or info or an article or something that I could educate myself with in terms of...

Hi Forum -- I'm looking for advise to assign values in column B to the unique values in column A. The results will look like column C. Thanks! ------ A | B ------ A | B | C | 1 C | 2 C | 3 --- C --- A1 A2 A3 B1 B2 B3 C1 C2 C3

I have a formula in a Module that I want to assign to Column H. This formula determines if the training date is past Today() and will either display Not Qualified or Fully Qualified. Column H is dynamic based on the amount of training required for the job selected. I currently have it housed in...

Creating a dashboard that will run 250 different individual tasks (and some buttons that will run sets of these individual tasks), but the process of creating a button and assigning a macro to it (250 times) is tedious. Wondering if there is CODING way to assign macros to existing buttons OR...

Hi Can I wrote a code to undo whatever I have done. at any level, Sheet/Range/cells. I just want to create a button and assign macro to that button to undo whatever user did? Thank you so much.

Hi I can insert a Form Control and then assign Macro to it (right click, assign macro). But that is not the case with ActiveX Control. There is no "assign macro" option when you click on ActiveX Control. What is the reason behind that? Thank you.