Click here to Skip to main content
15,908,673 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: VBA Macro Assistance with IBM Reflections Pin
Dave Kreskowiak6-Dec-07 9:23
mveDave Kreskowiak6-Dec-07 9:23 
Generaladjusting ruler measurement in crystal report Pin
jhyn6-Dec-07 3:08
jhyn6-Dec-07 3:08 
GeneralProtecting S/W Piracy. Pin
Kumaran21cen5-Dec-07 23:15
Kumaran21cen5-Dec-07 23:15 
GeneralRe: Protecting S/W Piracy. Pin
harveyhanson5-Dec-07 23:27
harveyhanson5-Dec-07 23:27 
GeneralRe: Protecting S/W Piracy. Pin
Kumaran21cen5-Dec-07 23:30
Kumaran21cen5-Dec-07 23:30 
GeneralRe: Protecting S/W Piracy. Pin
nlarson116-Dec-07 4:52
nlarson116-Dec-07 4:52 
GeneralRe: Protecting S/W Piracy. Pin
Mark Churchill6-Dec-07 5:20
Mark Churchill6-Dec-07 5:20 
GeneralLoop Help Please Pin
harveyhanson5-Dec-07 22:55
harveyhanson5-Dec-07 22:55 
I am trying to do this loop, so it checks if a value entered is present, if not, it deletes the row, however, the process hangs once it finishes, how do i end the statement (i.e. when all records have been checked, display a message box), as I am not sure where to end it (I thought the end if and wend would end the statement, but do I possibly need an else somewhere?), cheers

p.s. this is VBA in excel 2003, but I assume its the same principal as VB

----
'When a cell contains data, perform the IF...
While Len(Range("B" & CStr(LFindRow)).Value) > 0

'If the cell does not contain the inputted criteria then delete the row
If Range("B" & CStr(LFindRow)).Value <> CustVar Then
Rows(CStr(LFindRow)).Delete

'End the IF
End If

'End/Loop the while
Wend
----
GeneralRe: Loop Help Please Pin
Luc Pattyn6-Dec-07 1:05
sitebuilderLuc Pattyn6-Dec-07 1:05 
GeneralRe: Loop Help Please Pin
soporificeffect6-Dec-07 2:45
soporificeffect6-Dec-07 2:45 
GeneralMaintaining form layout despite resolution change Pin
Ahmad Zaidi5-Dec-07 22:48
Ahmad Zaidi5-Dec-07 22:48 
GeneralRe: Maintaining form layout despite resolution change Pin
harveyhanson5-Dec-07 22:58
harveyhanson5-Dec-07 22:58 
Questiongroup policy Coding Pin
skhurams5-Dec-07 20:52
skhurams5-Dec-07 20:52 
GeneralRe: group policy Coding Pin
Dave Kreskowiak6-Dec-07 9:22
mveDave Kreskowiak6-Dec-07 9:22 
QuestionHow to display Crystall Reports. Pin
SekharOne5-Dec-07 19:57
SekharOne5-Dec-07 19:57 
AnswerRe: How to display Crystall Reports. Pin
Ujjaval Modi5-Dec-07 20:23
Ujjaval Modi5-Dec-07 20:23 
GeneralRe: How to display Crystall Reports. Pin
.Net Programmer(129399)15-May-08 10:35
.Net Programmer(129399)15-May-08 10:35 
AnswerRe: How to display Crystall Reports. Pin
CKnig5-Dec-07 20:23
CKnig5-Dec-07 20:23 
QuestionThread.Sleep() executed before finishing Paint Event Pin
bj930815-Dec-07 18:01
bj930815-Dec-07 18:01 
GeneralRe: Thread.Sleep() executed before finishing Paint Event Pin
CKnig5-Dec-07 18:23
CKnig5-Dec-07 18:23 
QuestionRe: Thread.Sleep() executed before finishing Paint Event Pin
bj930816-Dec-07 18:27
bj930816-Dec-07 18:27 
GeneralRe: Thread.Sleep() executed before finishing Paint Event Pin
Dave Kreskowiak7-Dec-07 1:37
mveDave Kreskowiak7-Dec-07 1:37 
GeneralRe: Thread.Sleep() executed before finishing Paint Event Pin
bj930817-Dec-07 16:22
bj930817-Dec-07 16:22 
GeneralRe: Thread.Sleep() executed before finishing Paint Event Pin
Dave Kreskowiak8-Dec-07 3:57
mveDave Kreskowiak8-Dec-07 3:57 
GeneralRe: Thread.Sleep() executed before finishing Paint Event [modified] Pin
bj9308110-Dec-07 7:43
bj9308110-Dec-07 7:43 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.