Forms in VBA on web

[1KN]

Hello All; this is my first post so I hope I am doing it right. A little background on my problem: I have 30+ spreadsheet "databases" (mere tables) of data that has been sorted and separated by type. These will be posted to the web via a group web site (which I am also coding for... old-fashioned DHTML).

I have created a user-friendly form in VBA with CommandButtons that are each linked to a specific sheet of data. When a button is clicked, the user can view the sheet they desire. I have created an additional CommandButton which is attached to a macro which runs a standard deviation calculation, based on which sheet is selected (i.e. if sheet 5A is selected, the calculation is run for the data range in sheet 5A).

Now my problem is that I cannot get the data value to be returned in the UserForm in a textbox I designated. Is it possible in VBA to have a calculation run in the background & a form in the foreground which will return a summary value (e.g. standard deviation) per form? Do I need to switch to Access? I would rather stick w/ XL if at all possible.


Thank you for your time, 1KN

 

[SkipVought]

Hi,

Looks like you did post in a separate thread.

So the process is, the user makes a selection, some code is run related to data on a specific sheet, and you somehow can't return the results to the form? Where do the results end up?

Skip,

_{[red]Be Advised![/red] The Vinyards of Texas have produced a wine with diuretic dimishment and urethric relief...
Pinot More!}

 

[1KN]

Hello,

Yes, you have the process right. The value is returned in the sheet (as if I were running a macro w/o any form at all); I cannot get it from the cell of the sheet onto the form. I am starting to wonder if it is not possible.

Thank you,
1KN

 

[SkipVought]

MyForm.MyTextbox.Text = SomeSheet.[SomeCellReference].Value

Skip,

_{[red]Be Advised![/red] For those this winter, caught in Arctic-like calamity, be consoled...
Many are cold, but few are frozen!}

 

[1KN]

Thank you! testing it now... (not that I doubt you).