473,378 Members | 1,555 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,378 software developers and data experts.

Restore the contents of the active cell

Legend7
How to restore the contents of the active cell to "0" if the user entered a non-numeric value into it?
Jun 12 '10 #1
0 994

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Scott Meddows | last post by:
How do I set row x and column y active in a datagrid? Thanks Scott
1
by: Don | last post by:
George Shepherd's great Windows Forms FAQ has this article about creating a datagrid with no active cell: http://www.syncfusion.com/faq/winforms/search/856.asp Unfortunately, this only works...
0
by: Islandbuoy | last post by:
Hi all, A VB learner on the loose here - keen as mustard but thoroughly confused !! I wish to change both the Interior Colour Index & Font Colour Index in a specific cell when that cell only is...
0
by: VBDevo | last post by:
Hello, Can anyone help me in this please I'm trying to restore an Active Directory deleted user, I found the code only in c++ in the MSDN, and it uses the DLL : wldap32.dll , which is under...
0
by: skihappy | last post by:
I want to return the contents of a cell, similar to array(x,y) from a select statement, and have tried the following: SELECT TOP 100 PERCENT dbo.ReturnDoorPrice(dbo..DoorStyle, dbo..UnitNo) AS...
4
by: scolivas | last post by:
I am wanting to let viewers know why a refreshable spreadsheet did not refresh. Often times its an ODBC time out error - I put an error handler into the macro that runs the refresh - so that it will...
1
by: Devo | last post by:
Hi I'm a bit of a VB novice so this is probably a very simple question for the gurus.. I'm running Excel 2000 under WindowsXP. I'm trying to determine if the selected cell on a sheet is...
1
by: poops2468 | last post by:
I have a very large DataGridView. When the user is done entering data, they click a button to perform calculations. The last cell the user entered data on remains highlighted (blue in my case). This...
0
by: prakashsakthivel | last post by:
Hi Members One excel sheet has some external link through DDE. I want to move cell contents with data link while coping one excel to another excel sheet. I got only value not that link...
1
by: chazzy69 | last post by:
Hi i know that u can delete and entire field from a table i.e. DELETE FROM table WHERE bla="bla" But what i want to do is only delete the stuff contained in one cell of the field i.e. rather...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.