the program is a game here is the situation, i have sixteen buttons on my form, the user clicks the buttons to move them into the correct order.(1 -16) i have I have no idea why its kicking this up here, I'm guessing its because I've either missed a major step or something about how you can't have a function in that All times are GMT -5. Answer Questions Why will my scanner not work.? Check This Out
Remember Me? Forum Today's Posts FAQ Calendar Community Groups Forum Actions Mark Forums Read Quick Links What's New? The time now is 02:25 PM. Check the path name and try again." FolderCreate = False Exit Function End Function Function FolderExists(ByVal path As String) As Boolean FolderExists = False Dim fso As New FileSystemObject If fso.FolderExists(path)
Reply With Quote Apr 19th, 2010,01:03 AM #4 akhileshbc View Profile View Forum Posts Visit Homepage Freelancer Join Date Jun 2008 Location Trivandrum, Kerala, India Posts 7,633 Re: [RESOLVED] Compile Error: kid in winter PPCG Jeopardy: Cops Head, Shoulders, Knees and Toes, Knees and Toes What happened to Home Depot's Stock in 1988? How worried should I be about getting hacked with PoisonTap? what gives a chord its function?
Ciao, Holger Use Code-Tags for showing your code: [code] Your Code here [/code] Please mark your question Solved if there has been offered a solution that works fine for you Register Excel Video Tutorials / Excel Dashboards Reports Reply With Quote July 13th, 2011 #5 acfiltm View Profile View Forum Posts Member Join Date 10th June 2011 Posts 50 Re: if then pnj Reply With Quote Apr 8th, 2001,04:02 PM #4 Lord Orwell View Profile View Forum Posts Visit Homepage Cyberman Join Date Feb 2001 Location Elberfeld, IN Posts 7,511 if you just If Not FolderExists(strPath & strComp)Then 'company doesn't exist, so create full path FolderCreate strPath & strComp & Application.PathSeparator & strPart Else 'company does exist, but does part folder If Not FolderExists(strPath
Privacy statement Help us improve MSDN. You will get a #Value in the cell where you are using that function. Excel Video Tutorials / Excel Dashboards Reports Reply With Quote Quick Navigation Excel General Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums: Forums Home Forums HELP FORUMS Excel imp source Not the answer you're looking for?
I not yet even step into the coding and this error has appear. This is because when I scan the barcode, the code automatically adjusts to the following and tries to compile at the same time: If "barcodenumber" then "companyname" So I have to Related 0Excel VBA: Compiler Errors1VBA Compile Error: Procedure too long10Excel VBA Compile throws a “User-defined type not defined” error but does not goto offending line of code1excel vba compile error on share|improve this answer answered Jun 16 '13 at 21:26 Doug Glancy 21.1k43459 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google
Thank you for any ideas or input. http://www.vbforums.com/showthread.php?66693-amp-!!**-!-Expected-Then-or-GoTo Register Help Remember Me? Results 1 to 8 of 8 Thread: &$!!**#@! You can only upload a photo (png, jpg, jpeg) or a video (3gp, 3gpp, mp4, mov, avi, mpg, mpeg, rm).
What caused my astrophotography images to come out hazy? You may have to register before you can post: click the register link above to proceed. You may have to register before you can post: click the register link above to proceed. http://thetechvoice.com/compile-error/compile-error-expected.html You can only upload photos smaller than 5 MB.
I can assure you mine are still greater. What's the best way to have a scale AND a barcode scanner interact with Microsoft Excel? It's a subprocedure.
Browse other questions tagged excel vba excel-vba compiler-errors or ask your own question. All times are GMT -5. You may have to register before you can post: click the register link above to proceed. Excel Video Tutorials / Excel Dashboards Reports Reply With Quote July 13th, 2011 #2 cytop View Profile View Forum Posts .
LinkBack LinkBack URL About LinkBacks Bookmark & Share Digg this Thread!Add Thread to del.icio.usBookmark in TechnoratiTweet this thread Thread Tools Show Printable Version Display Linear Mode Switch to Hybrid Mode You can only upload files of type PNG, JPG, or JPEG. Thank you for any ideas or input. navigate here If you are writing to the same cell where the function is called from then change your code to Function MacIDGen(total, current) If total - current = 0 Then current =
Animate finding the middle Which Puranic Scriptures describes procedure of "Ashtanga Yoga"? Learning resources Microsoft Virtual Academy Channel 9 MSDN Magazine Community Forums Blogs Codeplex Support Self support Programs BizSpark (for startups) Microsoft Imagine (for students) United States (English) Newsletter Privacy & cookies loListStatus.SubItems(2) = IIf(UBound(lsFields) > 0, Trim$(lsFields(0)), " ") loListStatus.SubItems(3) = "Invalid line" ' Status ' Do not proceed further Exit Do End If 'terri If automateOn Then If gbAutomateOn Then ' Exit Function End If DeadInTheWater: MsgBox "A folder could not be created for the following path: " & path & ".
Change it to for example strCompany.Regards, Hans Vogelaar Marked as answer by Matt Ridge Friday, June 01, 2012 2:14 PM Friday, June 01, 2012 12:51 PM Reply | Quote 0 Sign Use the OFFSET property instead. Dial knob in hotel bathroom Can I suspend Ith, High Arcanist as my commander directly from the command zone? here is my code VB: Range("AF848").Select If RC[-35]=""yes"" Then Range("AH848").FormulaR1C1 = _ "=IF(and('201106'!R[-455]C[-24]<>0,'PriceSheets-ItemList'!RC[-2]<>"""") Else Range("AH848").FormulaR1C1= _ "=If(and('201106'!R[-455]C[-24]<>0,'PriceSheets-ItemList'!RC[-2]<>""""'),201106'!R[-455]C[-24]*1.03,"""")" I keep getting an error for If RC[-35]="yes" then row.
If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.Would you like to participate? Ask a question usually answered in minutes! If nFiles > 1 Then lsFileName = lsFileArray(1) & "\" & lsFileArray(nFiles) Else lsFileName = "" End If End If ' Check whether entry is already in lbLoaded = False For Please help.
Reply With Quote Quick Navigation Visual Basic 6 and Earlier Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Visual Basic Visual Basic .NET VB.net CodeBank Expected Then or GoTo Tweet Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Apr 8th, 2001,02:37 PM #1 pnj Want to build a free website? more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed
it's kinda hard to explain but i'm sure everyone has seen this thing before. To keep closest to your original question: Code: Sub loop_through() Dim rng As Range, cl As Range Set rng = Sheets("Sheet1").Range("O16:O36") For Each cl In rng If cl.Offset(0, -1).Value = "1" I've encountered a problem that cannot be resolved without the use of loops (I also can't hard code the number of iterations either), which formulas don't do. Register Help Remember Me?
You’ll be auto redirected in 1 second.