LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default what do I do wrong?

ehmmm... a last question and hopefully I will be done with my sheet...
My sheet contains 2 tables of 4 columns / 17 rows each
The data for these tables SHOULD come from an userform (which I've already
made). When the "ready" button in the userform is pushed the data should go
in the first empty row (this is what I use for this purpose):

Private Sub cmdNext_Click()
ActiveWorkbook.Sheets("Sheet1").Activate
Range("B16").Select
Do
If IsEmpty(ActiveCell) = False Then
ActiveCell.Offset(1, 0).Select
End If
Loop Until IsEmpty(ActiveCell) = True

Next step is where everything goes wrong:

now the data has to be input in the right place and this is what I do:

ActiveCell.Value = txtCode1.Value
ActiveCell.Offset(0, 1) = txtCode2.Value
ActiveCell.Offset(0, 2) = txtDate.Value
End sub

Apparently this code is not working. All I get is the first line highlighted
and that's it.

Furthermo when the first table is full (4 colums / 17 rows) I need the
data to go to the next table which start at the same hight as the first (say
row 16) but 7 columns to the right....

Sorry for the lenght of this but english is not my language and I don't know
how to keep it short...

Thanks for any help....


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert Calculated Field (wrong Qty*Price = wrong Amount) Edmund Excel Discussion (Misc queries) 8 October 4th 07 12:13 PM
Any wrong with this? Jo[_2_] Excel Discussion (Misc queries) 1 August 2nd 07 09:48 PM
Getting wrong value due to ref? jesmin Excel Discussion (Misc queries) 2 March 16th 06 02:12 AM
Please Tell Me What I Am Doing Wrong kidd Excel Programming 0 October 30th 04 01:30 AM
What is wrong?? willroy[_2_] Excel Programming 1 December 12th 03 01:33 PM


All times are GMT +1. The time now is 04:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"