Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop thought contents
Hi all,
I have excel sheet and want to loop thought it contents and show the value of the contents on a form. This the code I have and it just wont work and I cant see why any help be great thanks? Dim intshowrow As Integer intshowrow = 0 Do Until Data.Range("a2").Offset(intshowrow, 0).Value < "" intshowrow = intshowrow + 1 Loop 'This will take the data enterd in the form and add it to the data sheet. Software_form.txtSoftware2.Value = Data.Range("a2").Offset(intshowrow, 0) Data.Range("a2").Offset(intshowrow, 0) = Software_form.txtSoftware2.Value It's Probley sumthing silly Why I am here I will also need to have an update button and Delete button. So when the user come's to data they want to update they can. And when they dont need data any more can press delete and it will remove the whole row what best way to do this ? once again thanks p.s I am pretty new to VBA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loop through range and add each cell contents to a string | Excel Programming | |||
How do I create a loop to merge contents of rows 1-4 across column | Excel Programming | |||
Don't think it's possible, but I thought I would ask. | Excel Worksheet Functions | |||
How easy is it to loop in VBA based on cell contents? | Excel Worksheet Functions | |||
On second thought ... | New Users to Excel |