FiveTech Software tech support forums

Inline Edit Behavior: During inline edit of a cell, by default, the changes are saved if the user confirms the changes either by pressing enter or any arrow keys. During the edit, if the Get loses focus, either by clicking another cell or changing ...

... COLSIZES 50,20,290,50 OF oDlg ; SIZE 300,238 PIXEL ; JUSTIFY .T.,.f.,.f.,.t. ; ALIAS cAlias AUTOSORT FOOTERS LINES CELL NOBORDER ; Font oFont; BACKGROUND aGrad VERTICAL oBrw:nStretchCol := 2 oBrw:nRowHeight := 30 oBrw:nMarqueeStyle := 4 // anulo el doble color d ...

... oRs:image := MEMOREAD( "picture.jpg" ) If you are browsing in XBrowse, you can copy image from any source and paste into the cell. This works for all datasources, viz, dbf, tdatabase, ado, fwmysql, dolphin, tmysql, postgre, arrays, etc.

... oRs:image := MEMOREAD( "picture.jpg" ) If you are browsing in XBrowse, you can copy image from any source and paste into the cell. This works for all datasources, viz, dbf, tdatabase, ado, fwmysql, dolphin, tmysql, postgre, arrays, etc.

... If oCol:nEditType is > 0 and oCol:lReadOnly is .F. ( default ) and oCol:bEditWhen is NIL (default ) or Evaluates to .T. inline edit of the cell is automatically available (whether oBrw:lFastEdit is .T. or .F. ) ... Methods oBrw:Edit( lAppend ) and oBrw:EditSource( lAppend ) are provided ...

... the power of xbrowse and fwh. Thanks for this great example. :D Only a little glitch... When the program starts and you reserve a first cell to a customer you can not immediately drag and drop this cell. First you must click at an other cell. Then after drag and drop works well. Regards, ...

Wow, Antonio thanks for this. Btw I have been utilizing ChatGPT this morning and although I have not solved my specific question, I have learned alot. Thanks, for the Tip, and I will now go through your answers and see if I can get this.

Answer using Google Bard: Sub AccessListBox()'Declare variablesDim oExcel As ObjectDim oSheet As ObjectDim oListBox As ObjectDim i As IntegerDim strValue As String'Set Excel objectSet oExcel = CreateObject("Excel.Application")'Set Excel sheet objectSet oSheet = oExcel.Sheet...

Sub SelectListBoxItem()    Dim wb As Workbook    Dim ws As Worksheet    Dim lb As ListBox    Dim cell As Range    Dim item As Variant    Dim targetValue As String        ' Assuming you have an open workbook, ...

... = xlWorkbook.Worksheets("Sheet1")xlWorksheet.Activate()cellAddress = "A1"cell = xlWorksheet.Range(cellAddress)For Each shape In xlWorksheet.Shapes    If shape.TopLeftCell = cell ...

I got plenty of answers from Google that didn't help. What exactly did you ask? I have no idea what the names of the list boxes are so I need to go through a process of getting a list of all of the list boxes and how to access. If it gives me the correct answer than you might never see me again on t...

Dear Byron,

I have just asked chatGPT about it and it provided answer and code, you may give it a try

Anybody had any luck with accessing Listboxes in excel using OLE. I have a spreadsheet with a Listbox in about every cell. The user is suppose to select the value from the list box to fill it out. I am trying to fill it out using Fivewin and Ole. Don't have complete access to the ...

... ) From whatsnew.txt * XBROWSE: - New: XBrColumn new DATA bCellToolTip: CodeBlock to return tooltip text. To show tooltip when mouse hovers over a cell. This supercedes oCol:bTooTip, which is depricated. Using bToolTip requires the programmer to write a separate function to naviato the mouse over ...

This is for afther FW 21.06.. ? Will upgrade for some of the new stuff ))) I'm using a function because I need the value of the cell to be formatted in some kind. cell = Black,White,Green,Blue,Orange Tooltip needs to show 1. Black 2. White 3. Green 4. Blue ... Time will be there afther ...