Is there a way to update a check box from a cell?
I have a formula in cell "P3" that returns either True or False. I
would like to have the Check Box "Check Box 140" update to checked if
True or unchecked if False. The formula in cell "P3" is a UDF that

All,
I am using Excel 2007. I create an Excel file with my C# app and all
is well.... except for add-ins. When I open the file that I created
add-ins are not enabled. Actually I think they are enabled, but the

If memory serves me right, I seem to remember a command in the BASIC language
that allowed for x number of spaces, say SPC(x). "X" would be caculated
taking the length of the longest line and adjusting it for each short line as
it was displayed.  Something like this was used to ...

I've been using a function "GetValue" which gets a value from a closed
workbook. (Found at: http://j-walk.com/ss/Excel/tips/tip82.htm) Works great
except I want to put this into a loop to reference different cells.  
Therefore I'm trying to change it so that it accepts TheRow and ...

i got a module to check if internet connection available. this takes about 30
to 60 sec's to check. when established userform1 load and the user can
continue.
i made userform4 with label1 to display when opening the workbook. in

I submitted this post without entering anything on the subject line.   So I
am re-entering this.  I need to create a function that can be placed in a
cell that will display the last number in another column.  Below are some
attempts, but no success.  Thanks for your help!

Yesterday I had the frustration of trying to figure out why there were
no tables listed by MSQuery/Microsoft Query when I tried to import
external data from one Excel workbook to another Excel workbook.  I
finally came across the answer that I had to have "Sytem Tables"

Below is the code I am trying to use, but I keep getting a type mismatch
(Runtime Error 13) on the line indicated with "ERROR".  The value I am
pulling into date2 is formatted as DATE within the spreadsheet.
What do I need to change?

how would i do this? we use always on adsl but will use this on a few
computers with out internet connection
workbook_open
if internet = on

I want to take the current range and assign it to a variable touse in
additional functions.
How do I assign the current range to a variable like X?
Thanks

Hello, could anyone please help, I created a User form in the excel, is there
a command line, so the user and click on it and print the form. Also, I want
to add a menu bar to the form, is there any way this could be accomplished?
appreciated for any assistances.

I  working on a project and I can't figure out how to rename each individual
column so that other users after me will know where to put specific
information.
PLEASE HELP.  I have to have this done by Monday afternoon. I have alreay

I have created a userform and understand how to populate data from a single
textbox/combobox to an 'ActiveCell', however, can't figure out how to
populate data from the single textbox/combobox to an entire area that I've
selected/highlighted.

i have a vba to retrieve text from a text file.  it works fine.
however, when the line of the text file starts with number, like this
2000 Office
then it can only retrieve "2000", not "2000 Office"

I'm  struggeling to understand this.
I need to work with some data columns from a xml file. The columns do
contain numbers with a comma as decimal seperator. Same as in the
control panel settings.