Writing in data from a userform to a spreadsheet

  • Thread starter Thread starter Lap
  • Start date Start date
L

Lap

I'm currently doing some work using Excel and VBA as part
of my dessertation but i'm stuck and really need help. Can
someone please help me!

The problem is that i'm writing data(numbers) from
textboxes in a userform and copying these values into a
column of cells on a spreadsheet, the problem is that the
SUM function does not work to sum up these values into
another cell. Excel sees these as blanks even though the
numbers do appear.

please can someone help me,
thanks

Lap
 
Couple of things to check:

1 The numbers are actual numbers and not preceeded with a ' character. This
indicates text and functions like SUM will ignore the values
2 If auto calculation is not turned on then the sheet won't update to
reflect the changes made from the form



--
Regards,


Bill Lunney
www.billlunney.com
 
And maybe the cells are just formatted as Text.

try
=istext(a1)
(use a problem address)

If it comes back true, you could change the text cells to number cells by
copying an empty cell and selecting your range of problem cells. Then
Edit|Paste Special|Check the Add operation.

Formatting the cell as text (before data is entered) is very similar to Bill's
suggestion that they might start with an apostrophe ('123).
 
Back
Top