16,916 Topics
![]() | |
I have a problem about using find method in Excel VBA. Here is my program:- ____________________________________________________________________________ Private Sub CommandButton2_Click() Dim MyProduct As Range Product = Range("F8").Value Set MyProduct = ThisWorkbook.Sheets("Sheet2").Columns("E").Find(what:=Client, LookAt:=xlWhole) [COLOR="Red"]ActiveSheet.Cells(8, 8).Value = MyProduct.Columns("G").Value[/COLOR] End Sub ____________________________________________________________________________ > how can I pull data in Columns(G) to Cells(8,8) >the program … | |
I'm doing tic tac toe. I am planning to show the scores of the users and computers using the same form. So, for each time the user or the computer loop, i need to add a timer to it so that it can update the scores. Refer to the source … | |
hi, i want to link to dll files in my project. I have the header and implementation files and object library file to that dll file. I don't know how to call the functions out of the dll file. I am using Visual studio.NET C++ IDE. Any help will be … | |
i am using some listboxes in my form to load data from textboxes.. in one text box , the entry is bit lengthier than others, but the list box size osnt enough to display the whole entry .. is there anyway in which i can increase the column width of … | |
hai i am working with vb6 with mapobjects2.4 and i wrote code for MaxFileBuffer Property and i also got the error message as ActiveX component cannot create object th code is as like below: Dim dc As New MapObjects2.DataConnection Dim geo As New MapObjects2.GeoDataset Dim layer As New MapObjects2.MapLayer Private … | |
dear brothers i have a problem in saving ma data in the database.so i need help thanks. | |
Hi, I am making a programme where I use a timer, I have 2 command buttons, one starting the timer, another stopping the timer, currently this works. But when i press the comand button starting the timer I want to have it reset to 0 because at the moment it … | |
[B][COLOR="Red"]Hello I am new to this site I wish you to help I use Visual Basic Version 6 and database ACCESS would connect database to the server So I can use the database in more than one device Example If the two fields in the database the First for the … | |
hello to everyone i am working with vb6 & mapobjects2.4 and also i wrote code for "To select features based on an SQL expression" and i got an error as "Object Variable or With block Variable not set" .i want solution for this this problem code: Dim recset As New … | |
[COLOR=#555555]Hi all![/COLOR] [COLOR=#555555]Can anyone tell me where can I find a source that will help me learn visual c++ win32, without com and mfc, just pure basic, visual c++?[/COLOR] [COLOR=#555555]I already programmed different programs, but I am having trouble, when I try to add more windows to my program, I … | |
It is possible to print 2 form in one paper page. Or Anybody know how to extend the form size. My problem is when i reached the maximum size of the form especially the vertical size or the height. I cannot add 3 or more line which is necessary to … | |
How can I link visual basic with sybase, cos I use sybse as my datasource. | |
Hello , I would like to know the difference ADODB and ODBC when connecting VB6 to an Access database . Is one prefered over the other and in what circumstances. Thanks , rucci . | |
actualli im creatin a database on the driving licnese issuing authority im a new vb user my problem is that i want the new validity date to be automatically displayed wen this text box is clicked the code im using is dim text1 as date dim text2 as date text1.text= … | |
I want to access cd drive but i don't know how to do this... there are a way to do this? i think it will use api function? what api function i have to use? thanks in regards... any help will be appreciated. | |
Hi, I feel kinda dumb asking this question but I just don't know what to do. I have made a program for myself and I put it (the exe in the Visual Studio 2005\Programs\Program1\Program1\bin\debug) on my other harddrive. When I try to run it I get an error (I don't … | |
hello all, been working on this assignment with the VB 2005 book for about a week now and i don't really understand where to go next. it's under lesson C exercise 3 where i have to calculate the amount of change and how many dollars, then quarters (dimes, nicks, pennies) … | |
Hi I don't know if this is the best place to post my question, but here is what I have and what I need to do: - I have 100 questions. Every question is in a cell (from B1 to B100). In cells A1..A100 I can say "yes" or "no" … | |
Hello, I am new to Visual Basic.NET, and programming. I am wondering if someone can help me get to understand the VB.NET language. I learned some visual basic 6, but none of that seems to works anymore in the new version. Before in VB6 I could make a chat client … | |
hi guys i need someone to help me on how to create blinking textboxes and commands.thanx in advance | |
Does anyone know how to use data to call access database ?? | |
Hi All, I just tried to write a code which, upon clicking on a button should send an email with attachment. I succeded by using some of the posts here, but however I need to add some special effects in between... In the body of the email, I need to … | |
Help ! I need help.. Our VB lecturer gave us a project. We can choose our own topic to develop. Great, we have the flexibility to choose any topic. :) After brainstorming, here's some ideas ; alarm clock, calculator & payroll generator. So, I'm here to dig ideas from brilliant … | |
Is there anyway of chaning the Y-axis on a line chart using the MSchart component. I know i can change the numerical values on it using the chart properties, however I wish to add strings to the Y-axis which relate to numerical values. For example for a datapoint of 50, … | |
Hi, I have created a module to calculate a level when given a score. How do I send the calculated level back into my main form? Thanks in advance | |
hi all, There is a tool in VB called Help Workshop. I want to create Help file for my project. Can anybody tell me the step by step process for creating help files through help shop. Thank in advance Regards Guest11 | |
Hi all, I am learning VB 6 and i a just a beginner and i need to know some programs who is made it i VB 6 so that i can have a reason why i am learning. If you can send me some pictures or some kind of program … | |
Hello! I m struggling with this button and/or code to work. The button with Process.Start opens any folder I want if I do not use Ifs and Elses, but I do need to open folder based on user selection of name in the combobox and one choice from two radio … | |
i need a code for adodb which can link my form in vb to a table in ms access which contains name and id as the fields.help please!! thanx | |
[B][B]hi brothers i need to know how to save and delete records i adodb[/B]. | |
I'm using CZKEM1 Class to create bio metrice attendance software i can extract fingerprint templates from device and vice versa but my problem is i cannot intialize the commands for press the finger while creating new user how can i initialize device for user action especially for Finger print ? | |
Hi, Just want to know how to make the item in list box and textbox appear together - sync? Tq | |
Hi. I have just recently bought Microsoft Visual Studio Professional 2005. It came with 14 CD's, which are SQL server 2005 Developer Edition 64-bit (2 cd's) SQL server 2005 Developer Edition IA 64-bit (2 cd's) Microsoft Visual Studio 2005 Pro Ed Academic (2 cd's) MSDN library for Visual Studio System … | |
When I try accesing private members of a class using friend functions after including the concept of templates in visual basic c++, the compiler shows me an error message that friend functions cannot access the private members declared in class. Please help..... | |
I am a new member to this community from Kabarnet Kenya and i hope that it will be usefull and interesting. i was in my internet search for a programming solution advice in Visual Basic when i came across DANIWEB. i find my self greatful being with experts. | |
Hi I recently made the "create yor first project" web browser that came with vb express 2005. I added a status strip with the progress bar but the bar doesn't seem to be linked to the page it doesn't have green lines when you are connecting to a page, what … | |
Hi friends, My project is in need of serial communication between two computers using VB6.0 and communication between PC and FM transciever thro' RS232. I'am a beginner to VB. kindly send me a code to the above specified communications. | |
While Creating DataSet on Red Colored statement error occured which is Mentioned in Green Color....(A'm using Visual Studio 2005 and SQL Server 2005) Please Help...... 'Create New DataSet Dim ds As New DataSet("DataSetVendorInfo") 'Create a new Table and Columns Dim dTable As New DataTable("Vendors") dTable.Columns.Add("Ven_ID", System.Type.GetType("System.Int32")) dTable.Columns.Add("FName", System.Type.GetType("System.String")) dTable.Columns.Add("LName", System.Type.GetType("System.String")) … | |
Hi, I am using Microsoft access and started developing a software for the admission of the college(10+2+3). but my problem is that i have done newuser creation, Change password coding but i am not getting an idea for forgot password. I have searched little bit on Internet but no luck … | |
Hi friends, Now I am some project using with mobile,plz help me on how i will use get connection to Mobile through Vb 6.0 | |
hi everyone, i'd been creating a tic tac toe game using VB 6.0 and it is working perfectly. And now i have to create a form which allow user to only uses keyboard to control the position of their choices instead of using click() command by mouse. Any method to … | |
[B]hi brothers i want to know how some one can design a form to allow a user to login and use his system and also how to change the user accont for other users[/B] | |
using visual studio 2005 this is the problem: say i have a solution with 3 projects: first - has some usefull utils functions and i build it as a static library second - a project that uses the utils. I link with the first and build as a static library … | |
i have a problem making the code for this logic i have 5textbox ,1 label and a command button on a form and need to do this: [QUOTE]if the value of the 1st textbox is greater than the 2nd,3rd,4th,5th then label1.caption = to the value of the 1st text box … | |
Anyone experience problems with a disappearing control focus rectangle when using an XP style manifest? Some check boxes and option boxes no longer show the focus rectangle when the control gets focus using the kayboard and the tab key. Some do, some don't. Rather strange. I've tried putting them in … | |
I tried to install Microsoft Visual Studio .Net Enterprise Architect 2003 in my computer which has Windows xp pro. Installation fails at the last stage while installing Webbrowser components. The error message I got is Error 1937. An error occurred during the installation of assembly. 'Microsoft.mshtml,version="7.0.3300.0",publickey token="b03f5f7f11d50a3a",culture="neutral",Fileversion="7.0.3300.0". The signature or … | |
I am using VBA to work with excel files. The code allows the user to select files, processes them and gives the req data from input files in Excel workbook. After ptocessing, the excel file will be set visible for the user and the objects are also set to Nothing. … | |
I'm having problems connecting to an access database using vb 2005 when in vista. No error messages are displayed and the code works fine on XP. The line of code connection.Open() just won't work, i would very much apreciate it if someone could shed some light on how to stop … | |
i'm creating an online booking system for my project.i need to link my html to VB6.how do i go about it. | |
[B]Hello Friends, On my web form there is one DropDown List Box which contains different Items.. and one TextBox, user will Enter Quantity in textBox.... Now problem is that I want to Add Item and Qty in DataGrid on the Same Page when I click on ADD Button......... Later on … |
The End.