Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cell Content from UserForm Not Retained
Hello again:
I'm a novice user and I have a created a UserForm for placing certain contents into particular cells. The problem is when I save and exit Excel and come back into the same workbook, if I click that cell the UserForm pops up as expected, but if I do not make a selection and close (click the close button, red 'x') the userform or cancel the userform the cell contents from the previous save disappear and the cell is blank. I would think the cell contents should stay as is until I put some information into the cell. Is there a way to keep the cell contents when I reopen Excel (from a previous save)and launch the userform, do not make a selection, and close or cancel the userform? Kind regards, D.Parker |
#2
|
|||
|
|||
There is probably some code in the userform closedown that populates that
cell, and if it is blank, it will populate it with blank. Test for blank before offloading to the sheet. Post back with userform code if you need more help. -- HTH Bob Phillips "D.Parker" wrote in message ... Hello again: I'm a novice user and I have a created a UserForm for placing certain contents into particular cells. The problem is when I save and exit Excel and come back into the same workbook, if I click that cell the UserForm pops up as expected, but if I do not make a selection and close (click the close button, red 'x') the userform or cancel the userform the cell contents from the previous save disappear and the cell is blank. I would think the cell contents should stay as is until I put some information into the cell. Is there a way to keep the cell contents when I reopen Excel (from a previous save)and launch the userform, do not make a selection, and close or cancel the userform? Kind regards, D.Parker |
#3
|
|||
|
|||
Bob:
Thanks again! On my activesheet I just initialized that variable to the current cell contents prior to calling the userform. Kind regards, D.Parker "Bob Phillips" wrote: There is probably some code in the userform closedown that populates that cell, and if it is blank, it will populate it with blank. Test for blank before offloading to the sheet. Post back with userform code if you need more help. -- HTH Bob Phillips "D.Parker" wrote in message ... Hello again: I'm a novice user and I have a created a UserForm for placing certain contents into particular cells. The problem is when I save and exit Excel and come back into the same workbook, if I click that cell the UserForm pops up as expected, but if I do not make a selection and close (click the close button, red 'x') the userform or cancel the userform the cell contents from the previous save disappear and the cell is blank. I would think the cell contents should stay as is until I put some information into the cell. Is there a way to keep the cell contents when I reopen Excel (from a previous save)and launch the userform, do not make a selection, and close or cancel the userform? Kind regards, D.Parker |
#4
|
|||
|
|||
What code is in the userform?
-- HTH Bob Phillips "D.Parker" wrote in message ... Bob: Thanks again! On my activesheet I just initialized that variable to the current cell contents prior to calling the userform. Kind regards, D.Parker "Bob Phillips" wrote: There is probably some code in the userform closedown that populates that cell, and if it is blank, it will populate it with blank. Test for blank before offloading to the sheet. Post back with userform code if you need more help. -- HTH Bob Phillips "D.Parker" wrote in message ... Hello again: I'm a novice user and I have a created a UserForm for placing certain contents into particular cells. The problem is when I save and exit Excel and come back into the same workbook, if I click that cell the UserForm pops up as expected, but if I do not make a selection and close (click the close button, red 'x') the userform or cancel the userform the cell contents from the previous save disappear and the cell is blank. I would think the cell contents should stay as is until I put some information into the cell. Is there a way to keep the cell contents when I reopen Excel (from a previous save)and launch the userform, do not make a selection, and close or cancel the userform? Kind regards, D.Parker |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
borders not aligned with cell content when printed | Excel Discussion (Misc queries) | |||
cell content | Excel Discussion (Misc queries) | |||
How can I make the bar that shows the content of the cell visible. | Excel Discussion (Misc queries) | |||
vlookup to extract part cell content | Excel Discussion (Misc queries) | |||
Transferring cell content between workbooks using cell references | Excel Discussion (Misc queries) |