I tried with this code. But it is not stopping the entry of the duplicate
row with the same file number.
file numbers may be given consequently 1,2,3 .,
if we enter file number 1 for twice, it would fire msgbox that it already
exists.
pls provide solution
On Wed, Sep 7, 2011 at 8:03 PM, m
thank you so much saber
On Wed, Sep 7, 2011 at 8:03 PM, mohd saber wrote:
> Hi Shankar,
>
> Please find the below updated data for the command file
>
> Private Sub CommandButton1_Click()
> ActiveWorkbook.Sheets("Employee Details").Activate
> Range("A1").Select
> Do
>
>If IsEmpty(ActiveCell)
Hi Shankar,
Please find the below updated data for the command file
Private Sub CommandButton1_Click()
ActiveWorkbook.Sheets("Employee Details").Activate
Range("A1").Select
Do
If IsEmpty(ActiveCell) = False Then
If activecell.value = txtfileno.value Then
ActiveCell.Offset(0, 1) = txtname.Te
I placed the following objects on my VBA excel
TextBoxes
a) file no
b) Name
Command buttons
a) Save
b) Update
In save button I have given code as@@@
Private Sub CommandButton1_Click()
ActiveWorkbook.Sheets("Employee Details").Activate
Range("A1").Select
Do
If IsEmpty
