Create Drop Down In Excel Using VB?
Dec 15, 2011I needed to create in-cell dropdownlist in excel using VB.NET[code]...
View 1 Replies
ADVERTISEMENT
VS 2010 Create Workspace Where Can Drag And Drop Icons And Create Connection
Mar 3, 2012I Want to develop a software like Yed.i just don know where to start.how we can create a workspace where i can drag and drop icons and create connection etc etc.
View 6 RepliesSQL Data Access: VB2008 / VB2010 - WinForms - Create A Datasourse And Drag / Drop Fields Or Tables On A Form To Create A Grid
Oct 22, 2010I have used VB (versions 2 - 6) through many years; however, I am crash-course training myself into the VB2008 / VB2010 world kicking a screaming. I would like suggestions as to what SQL database access method should I focus more on in my learning process without making me feel that I'm a million years behind. I know I have WinForms where I can create a datasourse and drag / drop fields or tables on a form to create a grid (not really what I'm looking for).
My trouble isn't so much designing the form but in how I access the database. Theres XML, LINQ to SQL, ADO.NET, and many other methods. Not only do I need to grasp these methods quickly but I also need to know what type of projects I should create. What I mean is...I was thinking that I would design a WinForm app; however, I see that there are WPF apps and others to chose from. This is getting deep. I know it depends on the project that I'm working on. My plans are to write an app based off of either an SQL Express 2008 or SQL Server 2008 database. This first app will be standalone for now but may later become multi-user. I know I'm far behind on my learning curve coming from VB6. I have read a bit on VB2005 / 2008 / 2010. I own
both VB2008 and VB2010. I use VB2008 at work. I know ADO.NET is still alive but by what I read online, it's a dying method and is only kept for backward compatibility. XML and LINQ to SQL and other methods are all pretty new to me.
DataGrid With Drag And Drop Like In Excel
May 10, 2010I don't know how exactly it is called but I look for a function like in Excel when I write e.g. in the first cell a 1 and then pull the field down with my mouse and it automatically completes the following cells like that:
1
2
3
Is it possible to this in VB.Net and how except that I have to add every time one I have no idea.
Search Through An Excel Drop Down List?
Feb 1, 2010So I have an excel app with a drop down list and it contains many values. Is there a way I can just search through that drop down list in vb.net? I can't seem to find where these values that populate the drop down list even come from So I thought just searching through it is easier?
View 1 RepliesDrag&drop In VisualStudioExpress2010 Using Excel Sheets
Feb 21, 2011I am experienced VBA programmer and I want to expand into Visual Studio 2010 (Express version at the moment, bacause it's free). What I need is some code samples to get me started. Possibly showing all relevant aspects. Here goes:
A form has products as icons (in ListView?) - ordering is done by drag and drop onto a basket Products will have color and size - selection is done by two TabStrips or similar feature ( if TabStrip control is still available in ViStuEx2010)Database might be Excel sheets if possible, but other free options are OK (if Excel can cooperate with ViStuEx2010). How about XML residing on the Web? SkyDrive?
Menu and starter of the application might be from Excel too - but I'll be glad to learn newer ways - code needed for both options: when Excel is a starter and compiled ViStuEx app. is a starter.
I imagine that many people write order taking applications using drag and drop interface.
Exception While Reading Excel Sheet Drop Down Value?
Dec 2, 2009Exception While Reading Excel Sheet Drop Down Value...
View 3 RepliesCreate Button With A Drop Down?
Aug 11, 2010Is it possible to create a button with a drop down, or a combobox that has the dropdown arrow along the bottom as opposed to the right hand side? I am trying to emulate the "Paste" button in the Word 2010 ribbon.
View 2 RepliesCreate Drop Down Menus Where The Url Goes Like IE8?
Jul 15, 2009Im a Noob at this this is my first creation, i want a step by step guide like if anyone can manage that i want to create drop down menus where the url goes like IE8 , also wanna create Tabs For Web Browser. I want To Also Make Favorites and history and thats it for now like IE8 Please Can Someone Help Me ill paste my code below
[Code]...
Cannot Create ActiveX Component - EXCEL - Does Server Have To Have Excel Installed
Apr 1, 2009I have read some of the other posts on this and seem to be a little different than my situation. Trying to print out some reports into an excel document on the clients machine - of course it works fine on my local (heard that before right). I went in and set my references Ms.Office.Core and Ms.Office.Interop.Excel to 'Copy Local' = True so the .dll are in the servers bin folder.
[Code]...
Create A Drop Down Box To Have It Display The Following Information 90, 89 And 70?
May 8, 2009I am trying to create a drop down box to have it display the following information 90, 89 and 70, with this code:
Private Sub AsuComboBox_Change()
End Sub
Create A Drop Down Navigation Menu?
Oct 16, 2009I have one navigational toolbar that will allow me to click from one record to another. I am supposed to also have a navigation menu that does the same thing. I have found no information in my book that works on this. Is there a better place to find this type of information?
View 1 RepliesPossible To Create Drag And Drop Toolbox?
Oct 13, 2011is it possible to create our own toolbox by which we drag and drop the tools?
View 2 RepliesCreate A Printer Drop Down List Like MS Word 2007
Nov 18, 2011Is possible to create a Printer drop down box like ms word, actually i need the icon of the installed printers on that system, because i have already got the printer collection from "System.Drawing.Printing.PrinterSettings.InstalledPrinters"
View 1 RepliesCreate An Image With Drop Shadow On Text Programatically?
Nov 1, 2010I'm currently building an intranet engine for a project I've got on the go at the moment,and I'd like to save myself a little time by generating header images from code where possible, however, I'd like it to match our concept image.What I'd like to achieve is below:My issue is I've not the faintest how to create that from code. I can do the absolute basics but that's about it.I start to fall down when it comes to the gradient background and the drop shadow on the text. I can get away with positioning the text on the larger header image, so if it's not possible to generate the exact gradient I have there, then I have a work around for that, but what I really want to achieve is the text with the font and drop shadow.
View 1 RepliesCreate An Excel File In Excel 2003?
Jun 24, 2009how can I create an excel file in excel 2003, open it, add workbook, write into it, save it and close it by visual basic 2008.
View 2 RepliesCreate An Excel File Without Excel Installed?
Feb 12, 2009Is there a way in VB .NET to create an Excel file without having Excel installed?
View 7 RepliesCreate A New For Open The Dataset Drag And Drop The Tables To Form?
Dec 31, 2009i have a few questions about seting up a form.when you creat a new for open the dataset drag and drop the tables to form it creates a top menu bar with pages plus sign and x and save.now when you run the app you need to press the plus sign to add data in the database..is there a way to make it that you dont need to press the plus sign?
View 3 RepliesC# - Drag And Drop From Excel Cells To A Drag-enabled Task Pane Programatically?
Oct 31, 2010I am using Excel 2007, VS2008 Pro.I am building a VSTO Add-in that requires "drag and drop from Excel cells to a drag-enabled task pane".So far I notice that I can only drag and drop within the cells themselves. It does not allow me to drop into the task Pane or drag past the sheet limits.(http:)[url]...
Note: The task pane has drag drop enabled, I ahve already tested I can drag/drop from task pane to excel but I need to do this the other way around?
Avoid Create/drop Table Scenario With A Perm Stage Table?
May 10, 2010I created a function that creates a global temporary table to stage data from a excel sheet I need the table to persist for me to map the columns using a form. The table is still there when the code goes back to the sub that calls the function until I call the form where I do the mapping. I am trying to avoid create/drop table scenario with a perm stage table.How can I get this table to persist until the data gets loaded into the perm table?
View 8 RepliesCreate A Richtextbox On Formload Then Drag And Drop On Richtextbox?
Jun 28, 2011I'm currently having a problem dragging and dropping my label1.text to a richtextboxt which isn't created on design time...well im currently found a solution but i think it is only for a temporary solution because i use a drag and drop i drag it to a textbox then it willl transfer the data to the richtextbox....through the use of the textbox... here is the code ive come through..[code]...
View 2 RepliesDrag/Drop In A Drop Down List?
Apr 5, 2011Is it possible to reorder the elements of a drop down list (combobox) via drag and drop?For example, when the list is dropped down, I want the user to be able to drag the items up or down to reorder them. I tried this (and some google searching) but I'm wondering if its just not possible:
Private Sub cmbClassLists_MouseDown(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles cmbClassLists.MouseDown
If cmbClassLists.DroppedDown And Not cmbClassLists.SelectedIndex = -1 Then
[code].....
VS 2005 ComboBox Drop Up Instead Of Drop Down
May 9, 2011ComboBox drop up instead of drop down..i want to defualt for a particular drop down box to work this way how can i do it.
View 6 RepliesCannot Create Activex / Using Excel In App
Feb 2, 2010I wrote an app that writes to an excel file. It works fine on my computer. I create the install through VS2008 and it adds the needed files such as the office dll files. After installing it on another machine it shows it cannot create activex. Does excel need to be installed on the machine? Or is this another type of error?
View 2 RepliesCreate A Button For Excel?
May 21, 2009Am i able to build a button that can be installed onto Excel 2003 using VB which will be displayed on the main toolbar (where file, edit, view insert etc)?
When the button is clicked it will run a macro to de-duplicate a report?
Create A COM Object To Use In Excel?
Jul 21, 2010I am using VB Express 2008, and I am trying to create a COM object to use in Excel. I have looked at the walkthroughs, but it seems they only apply to Visual Studio.
Is there a way to create a COM object in VB Express?
Create An Excel Spreadsheet?
Mar 31, 2011I am having trouble creating an excel spreadsheet and then importing data from a textbox file with heading 1 going in a1, heading2 going in a2 and the data being entered in in b1 and b2 etc.
View 1 RepliesCreate Excel From DataGridView?
Nov 15, 2010How do we create an excel file for each datatable of a dataset ?
I tried some codes I found in the net, they don't seem working, so can someone provide me a tutorial or code that shows how to create an excel file from datagrid view ??
How To Create Excel File(.xls) From .Net App
Jan 8, 2009SELECT * INTO [supplierexp] FROM [supplier] IN '' [ODBC;Driver={SQLServer};Server=(local);Database=sh op;user name='shop';password='abc123';Trusted_ Connection=yes];"For above code im getting error like ODBC--connection to '{SQLServer}(local)' failed. Im using the valid username and password only.How to remove the error
View 1 RepliesHow To Create Excel Sheet
Mar 9, 2012i created excel sheet in visual basic 6.0
Option Explicit
Dim val As Integer
Private Sub cmdCalculate_Click()
Dim exclApp As Excel.Application
[code]....
like this now i have to add records like if add values in my text box then it should to calculations and then it should be display in excel sheet i can open excel sheet but i cant add values?