Hi,
This can be done with data validation. Any particular reason you want to do it
with a macro?
Dave.
Date: Mon, 19 Apr 2010 04:11:02 +1300
Subject: Re: $$Excel-Macros$$ Data requeired please help me
From: mam...@gmail.com
To: excel-macros@googlegroups.com
Hi all,
I wanted to write a
Hi all,
I wanted to write a macro, to validate the data,
as in in col a i want only numbers to be entered, in col b i want only
text, col c i want alpha numeric.is it possible??if we try to enter wrong
data a msg box should pop up..am a beginner , pls help me with simple code.
Mamtha Nagaraj
Hi Rajesh,
Please check attached file.
regards,
Vijay
On Fri, Apr 16, 2010 at 4:18 AM, Rajesh Nair wrote:
> Please help
>
> -- Forwarded message --
> From: Rajesh Nair
> Date: Fri, Apr 16, 2010 at 4:16 AM
> Subject: $$Excel-Macros$$ Data requeired please h
Here it comes...
Feedback please.
Kind regards,
Paul Willekens
'===
Private Sub CommandButton1_Click()
Dim nColOut
Dim nRowIn
Dim nRowOut
nRowIn = 1
nRowOut = 6
nColOut = 7
While Len(Sheets("Sheet1").Cells(nRowIn, 2).Value) >
Please help
-- Forwarded message --
From: Rajesh Nair
Date: Fri, Apr 16, 2010 at 4:16 AM
Subject: $$Excel-Macros$$ Data requeired please help me
To: excel-macros@googlegroups.com
Hi All,
Please help me to pull data from sheet 1 to sheet2 in a column by clicking
a command
Hi All,
Please help me to pull data from sheet 1 to sheet2 in a column by clicking
a command button ans should be in column I6
Regards,
Rajesh. Nair
--
--
--
Some important links for excel users:
1. Follow us on TW
