The following code records the row and column of a selected cell.
[code]...
.
If MonthDGV.Rows(selectedRowIndices(0)).Cells(selectedColumnIndices(2)).Style.BackColor = Color.White Then but that is no use. As there could numerous selected cells all over the place, how would I check the BackColor of all the selected cells.
i tick a check box in my datagridview, the cell in column 3 of the same row will change colour? this needs to apply to all check boxes and corresponding cells.
View 5 RepliesSo I have got a program with a timer on, a few labels displaying coordinates, and two buttons. Here is my
[code]...
It displays the color of the pixel at the coordinate typed into the text boxes.I have a video of a tennis ball which is bouncing on the spot, and the background in brown, so when the tennis ball comes into view there is a significant color change and i want it to start and stop a timer each time the colour changes significantly.So my question is, how do i get it to check whether the colour chas changed significantly?
How can i replace selected cells in a datagridview by using copy and paste or some other method. I want to highlight a Row or Column and then replace all the highlighted cells with one value
View 3 RepliesIm trying to colour cells in a datagrid depending on the value of the cell. Ive got a situation where I the 1st time the grid id displayed the coluring doesnt work, but then if I refresh the grid the colouring does work.
[Code]...
I have managed to find code that allows me to fill the row but how do i limit it to fill the cell only.
Example code:
Option Explicit
Option Compare Text
Private Sub Worksheet_Change(ByVal Target As Range)
[Code]....
I've been searching around a lot to figure this out. I found some code that sort of works:
VB.NET
If String.IsNullOrEmpty(CStr(Me.dgvList.Rows(i).Cells(0).Value)) Then
End If
[code].....
i am creating an rtf editor and i am trying to Change the colour of selected text. at the moment my code changes the colour of the whole text, but i want to be able to highlight my text and have 2 seperate colours, below is my code. Have tried to add .selectedText in but it says it 'SelectedText' is not a member of 'System.Windows.Forms.ColorDialog'.
ColorDialog1.Color = Editor.ForeColor
If ColorDialog1.ShowDialog = Windows.Forms.DialogResult.OK Then
Editor.ForeColor = ColorDialog1.Color
End If
I have a treeview and if I click on another control the hightlight disappears so I set the HideSelection to false and now the highlight row changes to a really light gray. Is there a way to have it still as dark blue. The reason being is because the user is clicking on a row in a grid and dropping it on the treeview and I need it to be clear that it will add it to the selected node which needs to be clear.
View 3 RepliesI have DataGridView1 where there is numeric data present. I want the sum of selected cells of DataGridView1 in my TextBox1 just like MS-Excell. How can i do this?
View 6 RepliesI have a DataGridView with cells from a database file that contains data. Basically, I want to get the text from the selected cells in the DataGridView and display it in a textbox at the click of the button. The code for the button click event is:
Private Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim SelectedThings As String = DataGridView1.SelectedCells.ToString
TextBox1.Text = SelectedThings
End Sub
However in TextBox1 I get:
System.Windows.Forms.DataGridViewSelectedCellCollection
I'm thinking it isn't as simple as it seems. I'm a C developer just learning VB.NET.
VB 2010 form has 1 panel, 1 DGV in the panel, 1 TabControl with 3 tabs in the panel each tab has a DGV all 4 bound to the same DataSet through code.
I have a form that has multiple Datagridviews on it, 1 in the main portion of a panel and the other 3 in a tabcontrol. If I click on cell 0,4 of DGV1 cell 0,4 of DGV2 is also "hilighted" and the same goes in the reverse order. If I click on cell 1,4 in DGV 1, cell 0,1 is hilighted in DGV2 (basically it stays with the last selected col and what ever row for that DGV).
This isn't the functionality I'm really looking for here, when I single click or change cells on any of the DGV's I don't want any of the others doing anything.
As you can see there are 2 cells selected this was created by a single click in the 4th cell of Param0
Is there anyway to turn on/off selected cells on a dbgrid. I know you can change the background color but I want all cells to lose "focus" completely as I think they are interfering with the visible property of the rows when I try and hide certain rows.
View 12 RepliesI would like to copy only the selected rows, but not all cells, only the ones I set in the sub, from one datagridview to another datagridview.
View 16 RepliesI've an excel sheet which is populated with thousands of rows of data, is there a way in vb.net I can pick out only selected cells/rows without having to go through every row?
View 2 RepliesI have a data grid view control which i populate using a random access file. What i want to do is when a user clicks on a cell, i want the data held in all the cells in the particular row to be used to populate some textboxes. i have searched everywhere and they all use sql databases.
View 2 Repliesi am having some problems running some code when there is a cell within my datagrid selected.is there some code i can use to deselect any cells that are selected within the datagrid?i have looked into this and tried, but nothing seems to do the right trick.
View 1 RepliesI have a DataGridView. I'd like the user to be able to select multiple cells using ctrl/shift. Then, as they type, I want the contents to update in all the selected cells. I'd prefer it if this happened as they type but I'd live with it updating the other selected cells when they leave the current cell.
I've tried hooking in to various events to to this but in each case there seems to be one problem or another that stops me doing it.
I am trying to change the font color of cell(s) that are selected by the user. So, the user highlights the cells, then presses a button to change the font color. I tried using datagridview1.selectedcells, but couldn't figure it out.
View 8 RepliesIn my Windows Form I have a ComboBox that is filled by a Stored Procedure with a list of names. I have the Combobox set for AutoComplete to "Suggest" and From "ListItems". When a user starts to type in and the AutoComplete does not find any matches in the listitems the user can tab out of the ComboBox and leave what they typed in the combobox even though it is not one of the Valid Items. Is there a way to check the Comboxbox to make sure of of the selected Items has been selected?
View 3 RepliesIs there any way to change the colour (background colour or text colour) of just a certain item or item(s)?
View 2 RepliesI want to know how many cell a namedRange contains . or want to check either a named range contains a single cell or multiple cells.
View 2 RepliesTo .NET after getting tired of using VB6 due to the lack of functionality. I'm trying to create a log on method for a system which will involve users selecting a colour from a paint panel and then placing/drawing the colour in 1 or more tiles of a grid, basically a 3x3 grid in which for example they selected the blue colour and drew in the top left tile and the bottom left tile. The logon is selecting the correct colour and placing the colour in the appropriate tile. What i want them to be able to do is place even a single pixel of colour so it has a high accuracy. So far i have a timer which loops from the width of the grid to the height of the grid.
Private Sub Timer1_Tick(sender As System.Object, e As System.EventArgs) Handles Timer1.Tick
Dim BMP As New Drawing.Bitmap(1, 1)
Dim GFX As System.Drawing.Graphics = System.Drawing.Graphics.FromImage(BMP)
GFX.CopyFromScreen(New Drawing.Point(MousePosition.X, MousePosition.Y), _
[CODE]...
To start with i have just hard coded the colour i want it to detect. At present it produces an error. Parameter must be positive and < Width the error is on System.Drawing.Point(i,j). If i place the mouse over the colour then run the program it will say it has been found, but otherwise it wont find the colour. I believe i am not updating the location of the pixel or something to that effect.
I've got a combobox which loads the system colour list, the selected colour is stored in the registry (i've tried storing the index number value aswell as the colour name - how can i get the combobox to display the stored colour as the default colour when the form loads? It always defaults to the first item in the colour list I've tried
[Code]....
My VB2010 programme changes the background colour of a button (butExtra.BackColor = Color.Red). But how do I restore the colour to the default "Control" colour?
View 2 Repliesi am looking to change the windows colour and colour intensity. These settings are accessable through Control PanelAppearance and PersonalizationPersonalizationWindow Color and Appearance But is there a way that i can remotely change these two settings through functions in my windows form application? Also is there any way of removing the slight blur on the window bars/taskbar when using an aero theme?
View 1 RepliesI'd like to replace all the white pixels in a bitmap image with pixels of the colour "Color.FromKnownColor(KnownColor.MenuHighlight)". Is there some method in the Image, Bitmap or Graphics classes I can use, or will I simply have to inspect each pixel in the image with GetPixel, check whether it is a white pixel, and then set it with SetPixel?Here is the code I am using now:
Private Shared Sub highlight(ByVal b As Bitmap)
Dim highlightColour As Color = Color.FromKnownColor(KnownColor.MenuHighlight)
Dim whiteARGB As Long = Color.White.ToArgb
[code]......
this is my very first posting and I must say I am desperate. I have a VB assignment due in 2 days and I am so lost. I have written a code to draw some graphic, just a basic house, tree, sun etc. I have also written a code to magnify said graphics which were all the specifications of my Assignment 1 part A. Now for Part B I am being asked to extend my program so that: A - My graphic can be drawn using different colour schemes designed by me but chosen by the user B - My graphic or an appropriate part of it can be animated around the picture box if the user chooses to do so. C - Error checking is included.
[Code]....
I am running a program that is connected through the internet and i gets disconnected at times.wanted to know how this would be to examine a color of a pixel , If the colour turns changes, my mouse will move to reconnect
View 8 RepliesMy main goal is to have an excel spreadsheet that automatically plots the overall success of my stock portfolio over time (% change over time). I've been able to incorporate stock data into my spreadsheet by linking it to the web, but the trouble is the spreadsheet will keep no history of what the previous stock values were, so I can't graph how things change over time. This sounds like it might be too complicated to be built in to excel, so I was wondering if anyone knew how to program this in Visual Basic. Maybe something like this.... If refresh then new cell plus new time stamp. Another possibility would be to have a whole bunch of cells that refresh only once but at longer and longer intervals, e.g.,
[Code]...