Randy Said:

How do I place labels on data points in Excel 2003?

We Answered:

easiest way is to insert text into a text box, then drag it to wherever you want it.

Miriam Said:

Excel IF Statement: if a cell equals a range of cells, then input a value from a range of cells in diff cell?

We Answered:

=IF() isn't what you need. =VLOOKUP() is the tool

This formula goes in the WinName position (D4) of the data sample you show. Modify the table range to stay put as you move this to the place and show positions. (Or use absolute referencing, better.)
=VLOOKUP(C1,A1:B5,2,FALSE)

Mae Said:

I want to modify this vba code?

We Answered:

Wow this brings back memories I haven't used vb for ages and forgotten how to code in it but if your just wanting to just add a text box can't you just do it through the form design.

Jimmie Said:

I have fewer ones than tens. The value of my tens is 30. What two numbers can I be?

We Answered:

1 or 2.

3 tens = 30 (value of tens)

You have less ones than tens, so if you have 3 tens, you can only have 1 or 2 ones.

Donald Said:

Excel formula to return value from worksheets?

We Answered:

try this method:
in TOC sheet cells a1 to a5 type names of sheet1 thru sheet5
in cells b1 thru b5 input the following formula exactly as shown:
=INDIRECT(ADDRESS(7,2,,,a1))
=INDIRECT(ADDRESS(7,2,,,a2))
=INDIRECT(ADDRESS(7,2,,,a3))
=INDIRECT(ADDRESS(7,2,,,a4))
=INDIRECT(ADDRESS(7,2,,,a5))

You'll see that the value in B7 of each corresponding sheet will display in the cell. B7 is row 7 and column 2 ... the 7 and 2 in the formula.

Diane Said:

To all expert excel users out there, i need some help with macros?

We Answered:

Are you using an actual Userform created in Excel VBA or referring to a worksheet as a 'form'?