assigning

Hello, new to VBA, so forgive my ignorance. I created a spreadsheet which I am adding data and assigning a number to the data. I have a search setup to make sure the number I am assigning is not already used. It works great except it cannot differentiate between say 75 and 175 or 1075, which...

Hello, So I have a group of text values for Sizes like twins, Small, Medium, Large etc. in a sheet and I'm assigning values to those sizes. I'm using the formula as below and it always gives me error. Please help. Here is the formula I'm trying to use, =LOOKUP('Prepaid Customer'!Y2,{"Twins"...

I am working with Form buttons and assigning macros to the buttons. When I first create a button, I can easily assign a macro by selecting Assign Macro from the shortcut menu. If I want to change the macro assigned to a button, or assign it after I have renamed the button, I cannot for the life...

Hi everyone, I am using =CHOOSE(RANDBETWEEN(1,2),"A","B") to randomly assign data into two groups A & B. But when I do for 120 contacts does not group them into two equal groups of 60, which is what I want. Instead, it will have one group with 68 and the other with 52. Does anyone know a...

Hi, New to VBA. I'm trying to understand the difference between assigning an array to another and not - the difference syntax and advantages/disadvantages etc I have two lots of code, as seen below. The first seems to work correctly, and does not rely on assigning parameters to an array...

I need assign the Click event of a label that was created programmatically. My code is working, but still can not assign the Click event dynamically: Public Sub Create_Label() Dim ctl As Control Dim pic2 As String pic2 = "C:\Documents\Pictures\Convert 24 bits.bmp" Set ctl =...

I am having a probelm with macros assigned to a custom toolbar. I am using excel 2003. 1. I have created several macros in a workbook named "PLAN" 2. I then created a custom toolbar. 3. Through the customize dialog box, I assign the Macros to the custom tool bar button. Everything work fine...

Hi all please may you help me with a formula to assign an "N" where a cell is blank eg. Column A = Grades A1 = B A2 = c A3 = d A4 = A5 = f A6 = G I would like A4 to return an N I know its an IF but I have been playing around with no joy! many thanks Rameses