assigning values

  1. W

    Assigning a file and path to a variable within VBA to be inserted as a formula

    To minimise the amount of changes I need to make when this bit of code is duplicated for other filenames, ALPHA-L4L.xlsm changing to BRAVO-L4L.xlsm and so on, I assigned the .xlsm file and its path to a variable so that I only need to make the change once (see black and bolded). Which is...
  2. H

    MS Word 2007 - values assignment to bookmarks

    Hello All,I am a newbie in MS-Word and need to find a way to access a given number of pre-defined bookmarks in a word-2007 document and assign values to their text property.Eg.How we access ranges in MS-Excel,Thisworkbook.sheets("sheet1").range("A1:C1").value = Array("Name","Age","Gender")So...
  3. V

    Assigning and declaring a alphanumeric value to a variable and referrring it through EXCEL VBA

    Hi All, I am new to this forum. But I am happy that I have registered with this because I have learnt lot many things through this forum. You people rock!!!!! And thank you!!!! Now I have one requirment, which is bothering me for the past 3 days. Hope you people can easily get me out of this...
  4. andrewb90

    Drop down box - assigning values

    Hello all, I am trying to set up a event sheet using drop down boxes to track points and events for each player. In the event tab: I have A3:A25 with different events I have three other sheets with players names on it (A3:A30) labeled Group 1,2,& 3. Each event uses two players and I would like...
  5. S

    Assigning Values to Columns in Excel 2003

    Hello. I did a survey in which residents of a public housing project were asked questions about whether or not they wanted educational programs and whether or not they would attend any on-site educational classes were they made available, such as GED classes and computer classes; and, whether...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top